Intro to Data Science - HW 6
Copyright Jeffrey Stanton, Jeffrey Saltz, and Jasmina Tacheva
# Enter your name here: Sana Khan Attribution statement: (choose only one and delete the rest)
# 1. I did this homework by myself, with help from the book and the professor.Last assignment we explored data visualization in R using the ggplot2 package. This homework continues to use ggplot, but this time, with maps. In addition, we will merge datasets using the built-in merge( ) function, which provides a similar capability to a JOIN in SQL (don’t worry if you do not know SQL). Many analytical strategies require joining data from different sources based on a “key” – a field that two datasets have in common.
Step 1: Load the population data
- Read the following JSON file, https://intro-datascience.s3.us-east-2.amazonaws.com/cities.json and store it in a variable called pop.
Examine the resulting pop dataframe and add comments explaining what each column contains.
library(tidyverse)
library(jsonlite)
dataset <- url("https://intro-datascience.s3.us-east-2.amazonaws.com/cities.json")
pop <- jsonlite::fromJSON(dataset)
pop## city growth_from_2000_to_2013 latitude longitude
## 1 New York 4.8% 40.71278 -74.00594
## 2 Los Angeles 4.8% 34.05223 -118.24368
## 3 Chicago -6.1% 41.87811 -87.62980
## 4 Houston 11.0% 29.76043 -95.36980
## 5 Philadelphia 2.6% 39.95258 -75.16522
## 6 Phoenix 14.0% 33.44838 -112.07404
## 7 San Antonio 21.0% 29.42412 -98.49363
## 8 San Diego 10.5% 32.71574 -117.16108
## 9 Dallas 5.6% 32.77666 -96.79699
## 10 San Jose 10.5% 37.33821 -121.88633
## 11 Austin 31.7% 30.26715 -97.74306
## 12 Indianapolis 7.8% 39.76840 -86.15807
## 13 Jacksonville 14.3% 30.33218 -81.65565
## 14 San Francisco 7.7% 37.77493 -122.41942
## 15 Columbus 14.8% 39.96118 -82.99879
## 16 Charlotte 39.1% 35.22709 -80.84313
## 17 Fort Worth 45.1% 32.75549 -97.33077
## 18 Detroit -27.1% 42.33143 -83.04575
## 19 El Paso 19.4% 31.77758 -106.44246
## 20 Memphis -5.3% 35.14953 -90.04898
## 21 Seattle 15.6% 47.60621 -122.33207
## 22 Denver 16.7% 39.73924 -104.99025
## 23 Washington 13.0% 38.90719 -77.03687
## 24 Boston 9.4% 42.36008 -71.05888
## 25 Nashville-Davidson 16.2% 36.16266 -86.78160
## 26 Baltimore -4.0% 39.29038 -76.61219
## 27 Oklahoma City 20.2% 35.46756 -97.51643
## 28 Louisville/Jefferson County 10.0% 38.25266 -85.75846
## 29 Portland 15.0% 45.52306 -122.67648
## 30 Las Vegas 24.5% 36.16994 -115.13983
## 31 Milwaukee 0.3% 43.03890 -87.90647
## 32 Albuquerque 23.5% 35.08533 -106.60555
## 33 Tucson 7.5% 32.22174 -110.92648
## 34 Fresno 18.3% 36.74684 -119.77259
## 35 Sacramento 17.2% 38.58157 -121.49440
## 36 Long Beach 1.5% 33.77005 -118.19374
## 37 Kansas City 5.5% 39.09973 -94.57857
## 38 Mesa 13.5% 33.41518 -111.83147
## 39 Virginia Beach 5.1% 36.85293 -75.97798
## 40 Atlanta 6.2% 33.74900 -84.38798
## 41 Colorado Springs 21.4% 38.83388 -104.82136
## 42 Omaha 5.9% 41.25236 -95.99799
## 43 Raleigh 48.7% 35.77959 -78.63818
## 44 Miami 14.9% 25.76168 -80.19179
## 45 Oakland 1.3% 37.80436 -122.27111
## 46 Minneapolis 4.5% 44.97775 -93.26501
## 47 Tulsa 1.3% 36.15398 -95.99278
## 48 Cleveland -18.1% 41.49932 -81.69436
## 49 Wichita 9.7% 37.68889 -97.33611
## 50 Arlington 13.3% 32.73569 -97.10807
## 51 New Orleans -21.6% 29.95107 -90.07153
## 52 Bakersfield 48.4% 35.37329 -119.01871
## 53 Tampa 16.0% 27.95058 -82.45718
## 54 Honolulu -6.2% 21.30694 -157.85833
## 55 Aurora 24.4% 39.72943 -104.83192
## 56 Anaheim 4.7% 33.83529 -117.91450
## 57 Santa Ana -1.2% 33.74557 -117.86783
## 58 St. Louis -8.2% 38.62700 -90.19940
## 59 Riverside 22.5% 33.95335 -117.39616
## 60 Corpus Christi 14.1% 27.80058 -97.39638
## 61 Lexington-Fayette 18.0% 38.04058 -84.50372
## 62 Pittsburgh -8.3% 40.44062 -79.99589
## 63 Anchorage 15.4% 61.21806 -149.90028
## 64 Stockton 21.8% 37.95770 -121.29078
## 65 Cincinnati -10.1% 39.10312 -84.51202
## 66 St. Paul 2.8% 44.95370 -93.08996
## 67 Toledo -10.0% 41.66394 -83.55521
## 68 Greensboro 22.3% 36.07264 -79.79198
## 69 Newark 2.1% 40.73566 -74.17237
## 70 Plano 22.4% 33.01984 -96.69889
## 71 Henderson 51.0% 36.03952 -114.98172
## 72 Lincoln 18.0% 40.82576 -96.68520
## 73 Buffalo -11.3% 42.88645 -78.87837
## 74 Jersey City 7.2% 40.72816 -74.07764
## 75 Chula Vista 46.2% 32.64005 -117.08420
## 76 Fort Wayne 1.0% 41.07927 -85.13935
## 77 Orlando 31.2% 28.53834 -81.37924
## 78 St. Petersburg 0.3% 27.77306 -82.64000
## 79 Chandler 38.7% 33.30616 -111.84125
## 80 Laredo 38.2% 27.53057 -99.48032
## 81 Norfolk 5.0% 36.85077 -76.28587
## 82 Durham 29.9% 35.99403 -78.89862
## 83 Madison 15.8% 43.07305 -89.40123
## 84 Lubbock 19.6% 33.57786 -101.85517
## 85 Irvine 61.3% 33.68395 -117.79469
## 86 Winston-Salem 16.9% 36.09986 -80.24422
## 87 Glendale 5.7% 33.53865 -112.18599
## 88 Garland 8.5% 32.91262 -96.63888
## 89 Hialeah 3.2% 25.85760 -80.27811
## 90 Reno 26.8% 39.52963 -119.81380
## 91 Chesapeake 15.1% 36.76821 -76.28749
## 92 Gilbert 96.0% 33.35283 -111.78903
## 93 Baton Rouge 0.4% 30.45828 -91.14032
## 94 Irving 19.1% 32.81402 -96.94889
## 95 Scottsdale 11.0% 33.49417 -111.92605
## 96 North Las Vegas 92.2% 36.19886 -115.11750
## 97 Fremont 10.0% 37.54827 -121.98857
## 98 Boise City 9.5% 43.61871 -116.21461
## 99 Richmond 8.2% 37.54072 -77.43605
## 100 San Bernardino 13.0% 34.10834 -117.28977
## 101 Birmingham -12.3% 33.52066 -86.80249
## 102 Spokane 7.0% 47.65878 -117.42605
## 103 Rochester -4.1% 43.16103 -77.61092
## 104 Des Moines 3.9% 41.60054 -93.60911
## 105 Modesto 7.7% 37.63910 -120.99688
## 106 Fayetteville 2.4% 35.05266 -78.87836
## 107 Tacoma 4.9% 47.25288 -122.44429
## 108 Oxnard 18.2% 34.19750 -119.17705
## 109 Fontana 38.3% 34.09223 -117.43505
## 110 Columbus 8.7% 32.46098 -84.98771
## 111 Montgomery -0.1% 32.36681 -86.29997
## 112 Moreno Valley 40.4% 33.94247 -117.22967
## 113 Shreveport -0.1% 32.52515 -93.75018
## 114 Aurora 38.4% 41.76058 -88.32007
## 115 Yonkers 1.8% 40.93121 -73.89875
## 116 Akron -8.6% 41.08144 -81.51901
## 117 Huntington Beach 3.9% 33.66030 -117.99923
## 118 Little Rock 7.6% 34.74648 -92.28959
## 119 Augusta-Richmond County 1.1% 33.47350 -82.01051
## 120 Amarillo 12.8% 35.22200 -101.83130
## 121 Glendale 0.3% 34.14251 -118.25508
## 122 Mobile -1.9% 30.69537 -88.03989
## 123 Grand Rapids -2.8% 42.96336 -85.66809
## 124 Salt Lake City 5.1% 40.76078 -111.89105
## 125 Tallahassee 21.8% 30.43826 -84.28073
## 126 Huntsville 16.3% 34.73037 -86.58610
## 127 Grand Prairie 43.1% 32.74596 -96.99778
## 128 Knoxville 3.9% 35.96064 -83.92074
## 129 Worcester 5.8% 42.26259 -71.80229
## 130 Newport News 0.9% 37.08708 -76.47301
## 131 Brownsville 26.8% 25.90175 -97.49748
## 132 Overland Park 19.4% 38.98223 -94.67079
## 133 Santa Clarita 15.3% 34.39166 -118.54259
## 134 Providence 2.3% 41.82399 -71.41283
## 135 Garden Grove 5.8% 33.77391 -117.94145
## 136 Chattanooga 10.5% 35.04563 -85.30968
## 137 Oceanside 6.6% 33.19587 -117.37948
## 138 Jackson -6.8% 32.29876 -90.18481
## 139 Fort Lauderdale 0.7% 26.12244 -80.13732
## 140 Santa Rosa 15.2% 38.44043 -122.71405
## 141 Rancho Cucamonga 32.7% 34.10640 -117.59311
## 142 Port St. Lucie 91.7% 27.27305 -80.35823
## 143 Tempe 5.8% 33.42551 -111.94001
## 144 Ontario 5.5% 34.06334 -117.65089
## 145 Vancouver 14.2% 45.63873 -122.66149
## 146 Cape Coral 60.4% 26.56285 -81.94953
## 147 Sioux Falls 31.1% 43.54460 -96.73110
## 148 Springfield 7.8% 37.20896 -93.29230
## 149 Peoria 46.5% 33.58060 -112.23738
## 150 Pembroke Pines 17.4% 26.00776 -80.29626
## 151 Elk Grove 97.1% 38.40880 -121.37162
## 152 Salem 16.4% 44.94290 -123.03510
## 153 Lancaster 33.8% 34.68678 -118.15416
## 154 Corona 23.6% 33.87529 -117.56644
## 155 Eugene 14.4% 44.05207 -123.08675
## 156 Palmdale 33.7% 34.57943 -118.11646
## 157 Salinas 8.4% 36.67774 -121.65550
## 158 Springfield 1.1% 42.10148 -72.58981
## 159 Pasadena 7.5% 29.69106 -95.20910
## 160 Fort Collins 26.6% 40.58526 -105.08442
## 161 Hayward 7.5% 37.66882 -122.08080
## 162 Pomona 2.1% 34.05510 -117.74999
## 163 Cary 55.1% 35.79154 -78.78112
## 164 Rockford -1.0% 42.27113 -89.09400
## 165 Alexandria 15.0% 38.80484 -77.04692
## 166 Escondido 10.7% 33.11921 -117.08642
## 167 McKinney 165.3% 33.19725 -96.63978
## 168 Kansas City 1.1% 39.11405 -94.62746
## 169 Joliet 36.5% 41.52503 -88.08173
## 170 Sunnyvale 11.9% 37.36883 -122.03635
## 171 Torrance 6.6% 33.83585 -118.34063
## 172 Bridgeport 5.4% 41.18655 -73.19518
## 173 Lakewood 1.9% 39.70471 -105.08137
## 174 Hollywood 4.8% 26.01120 -80.14949
## 175 Paterson -2.2% 40.91677 -74.17181
## 176 Naperville 12.0% 41.75084 -88.15354
## 177 Syracuse -0.9% 43.04812 -76.14742
## 178 Mesquite 14.7% 32.76680 -96.59916
## 179 Dayton -13.5% 39.75895 -84.19161
## 180 Savannah 7.5% 32.08354 -81.09983
## 181 Clarksville 36.9% 36.52977 -87.35945
## 182 Orange 7.7% 33.78779 -117.85311
## 183 Pasadena 3.8% 34.14778 -118.14452
## 184 Fullerton 9.8% 33.87036 -117.92430
## 185 Killeen 52.1% 31.11712 -97.72780
## 186 Frisco 287.7% 33.15067 -96.82361
## 187 Hampton -6.6% 37.02987 -76.34522
## 188 McAllen 27.6% 26.20341 -98.23001
## 189 Warren -2.3% 42.51446 -83.01465
## 190 Bellevue 19.1% 47.61038 -122.20068
## 191 West Valley City 22.2% 40.69161 -112.00105
## 192 Columbia 11.7% 34.00071 -81.03481
## 193 Olathe 40.4% 38.88140 -94.81913
## 194 Sterling Heights 5.2% 42.58031 -83.03020
## 195 New Haven 5.5% 41.30827 -72.92788
## 196 Miramar 74.7% 25.98608 -80.30356
## 197 Waco 12.5% 31.54933 -97.14667
## 198 Thousand Oaks 9.5% 34.17056 -118.83759
## 199 Cedar Rapids 5.4% 41.97788 -91.66562
## 200 Charleston 29.2% 32.77647 -79.93105
## 201 Visalia 33.6% 36.33023 -119.29206
## 202 Topeka 3.4% 39.05582 -95.68902
## 203 Elizabeth 5.5% 40.66399 -74.21070
## 204 Gainesville 12.8% 29.65163 -82.32483
## 205 Thornton 52.9% 39.86804 -104.97192
## 206 Roseville 56.2% 38.75212 -121.28801
## 207 Carrollton 14.9% 32.97564 -96.88996
## 208 Coral Springs 5.7% 26.27119 -80.27060
## 209 Stamford 7.6% 41.05343 -73.53873
## 210 Simi Valley 12.6% 34.26945 -118.78148
## 211 Concord 2.9% 37.97798 -122.03107
## 212 Hartford 0.6% 41.76371 -72.68509
## 213 Kent 54.3% 47.38093 -122.23484
## 214 Lafayette 11.0% 30.22409 -92.01984
## 215 Midland 30.4% 31.99735 -102.07791
## 216 Surprise 281.9% 33.62923 -112.36793
## 217 Denton 47.1% 33.21484 -97.13307
## 218 Victorville 87.6% 34.53622 -117.29276
## 219 Evansville -0.8% 37.97156 -87.57109
## 220 Santa Clara 17.4% 37.35411 -121.95524
## 221 Abilene 3.6% 32.44874 -99.73314
## 222 Athens-Clarke County 19.0% 33.95193 -83.35757
## 223 Vallejo 1.2% 38.10409 -122.25664
## 224 Allentown 11.2% 40.60843 -75.49018
## 225 Norman 22.0% 35.22257 -97.43948
## 226 Beaumont 3.7% 30.08017 -94.12656
## 227 Independence 3.2% 39.09112 -94.41551
## 228 Murfreesboro 65.1% 35.84562 -86.39027
## 229 Ann Arbor 2.0% 42.28083 -83.74304
## 230 Springfield 4.2% 39.78172 -89.65015
## 231 Berkeley 13.3% 37.87159 -122.27275
## 232 Peoria 3.0% 40.69365 -89.58899
## 233 Provo 10.0% 40.23384 -111.65853
## 234 El Monte -0.4% 34.06862 -118.02757
## 235 Columbia 34.0% 38.95171 -92.33407
## 236 Lansing -4.4% 42.73253 -84.55553
## 237 Fargo 24.9% 46.87719 -96.78980
## 238 Downey 5.3% 33.94011 -118.13316
## 239 Costa Mesa 2.4% 33.64113 -117.91867
## 240 Wilmington 24.8% 34.22573 -77.94471
## 241 Arvada 9.2% 39.80276 -105.08748
## 242 Inglewood -1.0% 33.96168 -118.35313
## 243 Miami Gardens 10.5% 25.94204 -80.24560
## 244 Carlsbad 39.7% 33.15809 -117.35059
## 245 Westminster 9.4% 39.83665 -105.03720
## 246 Rochester 23.9% 44.01212 -92.48020
## 247 Odessa 22.3% 31.84568 -102.36764
## 248 Manchester 2.9% 42.99564 -71.45479
## 249 Elgin 16.0% 42.03541 -88.28257
## 250 West Jordan 38.4% 40.60967 -111.93910
## 251 Round Rock 81.0% 30.50826 -97.67890
## 252 Clearwater 0.1% 27.96585 -82.80010
## 253 Waterbury 2.2% 41.55815 -73.05150
## 254 Gresham 20.7% 45.50014 -122.43020
## 255 Fairfield 12.8% 38.24936 -122.03997
## 256 Billings 18.6% 45.78329 -108.50069
## 257 Lowell 3.4% 42.63342 -71.31617
## 258 San Buenaventura (Ventura) 7.4% 34.27465 -119.22903
## 259 Pueblo 5.9% 38.25445 -104.60914
## 260 High Point 24.3% 35.95569 -80.00532
## 261 West Covina 2.3% 34.06862 -117.93895
## 262 Richmond 7.9% 37.93576 -122.34775
## 263 Murrieta 107.4% 33.55391 -117.21392
## 264 Cambridge 5.5% 42.37362 -71.10973
## 265 Antioch 16.9% 38.00492 -121.80579
## 266 Temecula 55.4% 33.49364 -117.14836
## 267 Norwalk 1.9% 33.90224 -118.08173
## 268 Centennial 3.5% 39.58075 -104.87717
## 269 Everett 9.4% 47.97898 -122.20208
## 270 Palm Bay 31.7% 28.03446 -80.58866
## 271 Wichita Falls 0.7% 33.91371 -98.49339
## 272 Green Bay 1.9% 44.51916 -88.01983
## 273 Daly City 1.0% 37.68792 -122.47021
## 274 Burbank 4.2% 34.18084 -118.30897
## 275 Richardson 13.2% 32.94833 -96.72985
## 276 Pompano Beach 4.0% 26.23786 -80.12477
## 277 North Charleston 27.4% 32.85462 -79.97481
## 278 Broken Arrow 28.2% 36.06095 -95.79745
## 279 Boulder 9.0% 40.01499 -105.27055
## 280 West Palm Beach 23.5% 26.71534 -80.05337
## 281 Santa Maria 30.9% 34.95303 -120.43572
## 282 El Cajon 7.4% 32.79477 -116.96253
## 283 Davenport 3.9% 41.52364 -90.57764
## 284 Rialto 9.8% 34.10640 -117.37032
## 285 Las Cruces 37.6% 32.31994 -106.76365
## 286 San Mateo 9.0% 37.56299 -122.32553
## 287 Lewisville 28.9% 33.04623 -96.99417
## 288 South Bend -6.8% 41.67635 -86.25199
## 289 Lakeland 18.3% 28.03947 -81.94980
## 290 Erie -2.8% 42.12922 -80.08506
## 291 Tyler 18.6% 32.35126 -95.30106
## 292 Pearland 117.2% 29.56357 -95.28605
## 293 College Station 45.2% 30.62798 -96.33441
## 294 Kenosha 9.5% 42.58474 -87.82119
## 295 Sandy Springs 17.4% 33.93044 -84.37331
## 296 Clovis 42.6% 36.82523 -119.70292
## 297 Flint -20.0% 43.01253 -83.68746
## 298 Roanoke 3.8% 37.27097 -79.94143
## 299 Albany 4.1% 42.65258 -73.75623
## 300 Jurupa Valley 33.99720 -117.48548
## 301 Compton 4.5% 33.89585 -118.22007
## 302 San Angelo 10.2% 31.46377 -100.43704
## 303 Hillsboro 36.4% 45.52289 -122.98983
## 304 Lawton 4.9% 34.60357 -98.39593
## 305 Renton 88.4% 47.48288 -122.21707
## 306 Vista 7.7% 33.20004 -117.24254
## 307 Davie 17.7% 26.07648 -80.25212
## 308 Greeley 23.1% 40.42331 -104.70913
## 309 Mission Viejo 2.9% 33.60002 -117.67200
## 310 Portsmouth -4.2% 36.83543 -76.29827
## 311 Dearborn -2.0% 42.32226 -83.17631
## 312 South Gate -0.8% 33.95474 -118.21202
## 313 Tuscaloosa 21.1% 33.20984 -87.56917
## 314 Livonia -5.4% 42.36837 -83.35271
## 315 New Bedford 1.2% 41.63622 -70.93420
## 316 Vacaville 5.4% 38.35658 -121.98774
## 317 Brockton -0.3% 42.08343 -71.01838
## 318 Roswell 15.2% 34.02324 -84.36156
## 319 Beaverton 17.0% 45.48706 -122.80371
## 320 Quincy 5.8% 42.25288 -71.00227
## 321 Sparks 39.4% 39.53491 -119.75269
## 322 Yakima 11.7% 46.60207 -120.50590
## 323 Lee's Summit 31.2% 38.91084 -94.38217
## 324 Federal Way 8.8% 47.32232 -122.31262
## 325 Carson 2.9% 33.83167 -118.28169
## 326 Santa Monica 9.6% 34.01945 -118.49119
## 327 Hesperia 46.1% 34.42639 -117.30088
## 328 Allen 104.0% 33.10317 -96.67055
## 329 Rio Rancho 74.4% 35.23275 -106.66304
## 330 Yuma 16.2% 32.69265 -114.62769
## 331 Westminster 3.9% 33.75134 -117.99399
## 332 Orem 8.5% 40.29690 -111.69465
## 333 Lynn 2.6% 42.46676 -70.94949
## 334 Redding 11.9% 40.58654 -122.39168
## 335 Spokane Valley 12.6% 47.67323 -117.23937
## 336 Miami Beach 3.3% 25.79065 -80.13005
## 337 League City 98.3% 29.50745 -95.09493
## 338 Lawrence 12.7% 38.97167 -95.23525
## 339 Santa Barbara 0.9% 34.42083 -119.69819
## 340 Plantation 8.6% 26.12759 -80.23310
## 341 Sandy 1.3% 40.56498 -111.83897
## 342 Sunrise 4.6% 26.16697 -80.25659
## 343 Macon -7.3% 32.84069 -83.63240
## 344 Longmont 24.4% 40.16721 -105.10193
## 345 Boca Raton 7.5% 26.36831 -80.12893
## 346 San Marcos 60.0% 33.14337 -117.16614
## 347 Greenville 41.9% 35.61266 -77.36635
## 348 Waukegan 0.5% 42.36363 -87.84479
## 349 Fall River -3.7% 41.70149 -71.15505
## 350 Chico 14.2% 39.72849 -121.83748
## 351 Newton 4.9% 42.33704 -71.20922
## 352 San Leandro 10.3% 37.72493 -122.15608
## 353 Reading 8.0% 40.33565 -75.92687
## 354 Norwalk 5.6% 41.11774 -73.40816
## 355 Fort Smith 8.6% 35.38592 -94.39855
## 356 Newport Beach 10.4% 33.61891 -117.92895
## 357 Asheville 19.6% 35.59506 -82.55149
## 358 Nashua 0.4% 42.76537 -71.46757
## 359 Edmond 26.9% 35.65283 -97.47810
## 360 Whittier 3.3% 33.97918 -118.03284
## 361 Nampa 57.9% 43.54072 -116.56346
## 362 Bloomington 1.3% 44.84080 -93.29828
## 363 Deltona 23.1% 28.90054 -81.26367
## 364 Hawthorne 2.3% 33.91640 -118.35257
## 365 Duluth -0.1% 46.78667 -92.10049
## 366 Carmel 60.4% 39.97837 -86.11804
## 367 Suffolk 33.5% 36.72821 -76.58356
## 368 Clifton 7.9% 40.85843 -74.16376
## 369 Citrus Heights -0.1% 38.70712 -121.28106
## 370 Livermore 15.1% 37.68187 -121.76801
## 371 Tracy 45.9% 37.73965 -121.42522
## 372 Alhambra -0.7% 34.09529 -118.12701
## 373 Kirkland 87.5% 47.68149 -122.20874
## 374 Trenton -1.2% 40.21705 -74.74294
## 375 Ogden 8.6% 41.22300 -111.97383
## 376 Hoover 32.7% 33.40539 -86.81138
## 377 Cicero -1.6% 41.84559 -87.75394
## 378 Fishers 114.8% 39.95675 -86.01335
## 379 Sugar Land 29.1% 29.61968 -95.63495
## 380 Danbury 11.4% 41.39482 -73.45401
## 381 Meridian 127.6% 43.61211 -116.39151
## 382 Indio 66.0% 33.72058 -116.21556
## 383 Concord 47.4% 35.40875 -80.57951
## 384 Menifee 95.0% 33.69715 -117.18529
## 385 Champaign 18.3% 40.11642 -88.24338
## 386 Buena Park 6.1% 33.86751 -117.99812
## 387 Troy 2.2% 42.60641 -83.14978
## 388 O'Fallon 62.6% 38.81061 -90.69985
## 389 Johns Creek 36.5% 34.02893 -84.19858
## 390 Bellingham 21.8% 48.74908 -122.47815
## 391 Westland -4.7% 42.32420 -83.40021
## 392 Bloomington 16.1% 39.16533 -86.52639
## 393 Sioux City -2.9% 42.49999 -96.40031
## 394 Warwick -4.6% 41.70010 -71.41617
## 395 Hemet 37.6% 33.74752 -116.97197
## 396 Longview 11.6% 32.50070 -94.74049
## 397 Farmington Hills -0.9% 42.49899 -83.36772
## 398 Bend 54.3% 44.05817 -121.31531
## 399 Lakewood 2.1% 33.85363 -118.13396
## 400 Merced 25.4% 37.30216 -120.48297
## 401 Mission 74.5% 26.21591 -98.32529
## 402 Chino 15.6% 34.01223 -117.68894
## 403 Redwood City 7.1% 37.48522 -122.23635
## 404 Edinburg 65.1% 26.30174 -98.16334
## 405 Cranston 1.4% 41.77982 -71.43728
## 406 Parma -5.9% 41.40477 -81.72291
## 407 New Rochelle 9.9% 40.91149 -73.78235
## 408 Lake Forest 4.2% 33.64697 -117.68922
## 409 Napa 8.4% 38.29754 -122.28687
## 410 Hammond -4.6% 41.58337 -87.50004
## 411 Fayetteville 32.9% 36.06258 -94.15743
## 412 Bloomington 20.1% 40.48420 -88.99369
## 413 Avondale 111.5% 33.43560 -112.34960
## 414 Somerville 1.6% 42.38760 -71.09950
## 415 Palm Coast 137.2% 29.58445 -81.20787
## 416 Bryan 19.3% 30.67436 -96.36996
## 417 Gary -23.4% 41.59337 -87.34643
## 418 Largo 5.1% 27.90947 -82.78732
## 419 Brooklyn Park 16.0% 45.09413 -93.35634
## 420 Tustin 15.6% 33.74585 -117.82617
## 421 Racine -4.4% 42.72613 -87.78285
## 422 Deerfield Beach 4.8% 26.31841 -80.09977
## 423 Lynchburg 19.5% 37.41375 -79.14225
## 424 Mountain View 10.1% 37.38605 -122.08385
## 425 Medford 17.1% 42.32652 -122.87559
## 426 Lawrence 7.5% 42.70704 -71.16311
## 427 Bellflower 6.3% 33.88168 -118.11701
## 428 Melbourne 5.9% 28.08363 -80.60811
## 429 St. Joseph 4.1% 39.76746 -94.84668
## 430 Camden -3.6% 39.92595 -75.11962
## 431 St. George 53.1% 37.09653 -113.56842
## 432 Kennewick 29.1% 46.21125 -119.13723
## 433 Baldwin Park 0.8% 34.08529 -117.96090
## 434 Chino Hills 13.6% 33.98982 -117.73258
## 435 Alameda 5.4% 37.76521 -122.24164
## 436 Albany -0.6% 31.57851 -84.15574
## 437 Arlington Heights -0.6% 42.08836 -87.98063
## 438 Scranton 0.0% 41.40897 -75.66241
## 439 Evanston 1.9% 42.04507 -87.68770
## 440 Kalamazoo -1.9% 42.29171 -85.58723
## 441 Baytown 13.1% 29.73550 -94.97743
## 442 Upland 9.5% 34.09751 -117.64839
## 443 Springdale 57.1% 36.18674 -94.12881
## 444 Bethlehem 5.2% 40.62593 -75.37046
## 445 Schaumburg -0.5% 42.03336 -88.08341
## 446 Mount Pleasant 53.2% 32.83232 -79.82843
## 447 Auburn 34.9% 47.30732 -122.22845
## 448 Decatur -8.7% 39.84031 -88.95480
## 449 San Ramon 65.8% 37.77993 -121.97802
## 450 Pleasanton 15.2% 37.66243 -121.87468
## 451 Wyoming 6.5% 42.91336 -85.70531
## 452 Lake Charles 3.0% 30.22659 -93.21738
## 453 Plymouth 12.0% 45.01052 -93.45551
## 454 Bolingbrook 29.7% 41.69864 -88.06840
## 455 Pharr 55.7% 26.19480 -98.18362
## 456 Appleton 4.5% 44.26193 -88.41538
## 457 Gastonia 8.2% 35.26208 -81.18730
## 458 Folsom 38.6% 38.67796 -121.17606
## 459 Southfield -6.7% 42.47337 -83.22187
## 460 Rochester Hills 5.7% 42.65837 -83.14993
## 461 New Britain 1.9% 41.66121 -72.77954
## 462 Goodyear 271.0% 33.43534 -112.35766
## 463 Canton -10.3% 40.79895 -81.37845
## 464 Warner Robins 45.7% 32.61300 -83.62420
## 465 Union City 7.4% 37.59339 -122.04383
## 466 Perris 98.7% 33.78252 -117.22865
## 467 Manteca 42.7% 37.79743 -121.21605
## 468 Iowa City 13.8% 41.66113 -91.53017
## 469 Jonesboro 28.3% 35.84230 -90.70428
## 470 Wilmington -1.6% 39.73907 -75.53979
## 471 Lynwood 2.0% 33.93029 -118.21146
## 472 Loveland 37.4% 40.39776 -105.07498
## 473 Pawtucket -2.5% 41.87871 -71.38256
## 474 Boynton Beach 17.3% 26.53179 -80.09055
## 475 Waukesha 8.0% 43.01168 -88.23148
## 476 Gulfport -0.6% 30.36742 -89.09282
## 477 Apple Valley 29.9% 34.50083 -117.18588
## 478 Passaic 4.3% 40.85677 -74.12848
## 479 Rapid City 17.9% 44.08054 -103.23101
## 480 Layton 20.2% 41.06022 -111.97105
## 481 Lafayette 14.5% 40.41670 -86.87529
## 482 Turlock 23.5% 37.49466 -120.84659
## 483 Muncie -0.7% 40.19338 -85.38636
## 484 Temple 27.1% 31.09823 -97.34278
## 485 Missouri City 31.1% 29.61857 -95.53772
## 486 Redlands 9.4% 34.05557 -117.18254
## 487 Santa Fe 10.5% 35.68698 -105.93780
## 488 Lauderhill 4.2% 26.14036 -80.21338
## 489 Milpitas 11.0% 37.43233 -121.89957
## 490 Palatine 4.5% 42.11030 -88.03424
## 491 Missoula 19.7% 46.87872 -113.99659
## 492 Rock Hill 36.0% 34.92487 -81.02508
## 493 Jacksonville 5.0% 34.75405 -77.43024
## 494 Franklin 48.5% 35.92506 -86.86889
## 495 Flagstaff 29.3% 35.19828 -111.65130
## 496 Flower Mound 32.5% 33.01457 -97.09696
## 497 Weston 34.5% 26.10037 -80.39977
## 498 Waterloo -0.5% 42.49279 -92.34258
## 499 Union City 1.7% 40.69759 -74.26316
## 500 Mount Vernon -0.2% 40.91260 -73.83708
## 501 Fort Myers 31.2% 26.64063 -81.87231
## 502 Dothan 16.6% 31.22323 -85.39049
## 503 Rancho Cordova 26.4% 38.58907 -121.30273
## 504 Redondo Beach 6.7% 33.84918 -118.38841
## 505 Jackson 12.9% 35.61452 -88.81395
## 506 Pasco 98.5% 46.23958 -119.10057
## 507 St. Charles 11.3% 38.78811 -90.49744
## 508 Eau Claire 8.7% 44.81135 -91.49849
## 509 North Richland Hills 20.2% 32.83430 -97.22890
## 510 Bismarck 20.1% 46.80833 -100.78374
## 511 Yorba Linda 13.4% 33.88863 -117.81311
## 512 Kenner -4.8% 29.99409 -90.24174
## 513 Walnut Creek 3.5% 37.91008 -122.06518
## 514 Frederick 25.9% 39.41427 -77.41054
## 515 Oshkosh 5.3% 44.02471 -88.54261
## 516 Pittsburg 16.6% 38.02798 -121.88468
## 517 Palo Alto 13.7% 37.44188 -122.14302
## 518 Bossier City 17.4% 32.51599 -93.73212
## 519 Portland 3.2% 43.66147 -70.25533
## 520 St. Cloud 10.9% 45.55795 -94.16324
## 521 Davis 11.9% 38.54491 -121.74052
## 522 South San Francisco 9.1% 37.65466 -122.40775
## 523 Camarillo 14.9% 34.21639 -119.03760
## 524 North Little Rock 9.0% 34.76954 -92.26709
## 525 Schenectady 6.7% 42.81424 -73.93957
## 526 Gaithersburg 24.2% 39.14344 -77.20137
## 527 Harlingen 11.6% 26.19063 -97.69610
## 528 Woodbury 39.8% 44.92386 -92.95938
## 529 Eagan 2.6% 44.80413 -93.16689
## 530 Yuba City 27.9% 39.14045 -121.61691
## 531 Maple Grove 27.3% 45.07246 -93.45579
## 532 Youngstown -20.2% 41.09978 -80.64952
## 533 Skokie 2.8% 42.03240 -87.74162
## 534 Kissimmee 32.6% 28.29196 -81.40757
## 535 Johnson City 16.2% 36.31344 -82.35347
## 536 Victoria 7.5% 28.80527 -97.00360
## 537 San Clemente 28.6% 33.42697 -117.61199
## 538 Bayonne 5.1% 40.66871 -74.11431
## 539 Laguna Niguel 2.8% 33.52253 -117.70755
## 540 East Orange -7.4% 40.76732 -74.20487
## 541 Shawnee 32.2% 39.02285 -94.71519
## 542 Homestead 100.7% 25.46872 -80.47756
## 543 Rockville 34.0% 39.08400 -77.15276
## 544 Delray Beach 6.1% 26.46146 -80.07282
## 545 Janesville 5.6% 42.68279 -89.01872
## 546 Conway 46.1% 35.08870 -92.44210
## 547 Pico Rivera 0.4% 33.98307 -118.09673
## 548 Lorain -7.2% 41.45282 -82.18237
## 549 Montebello 2.0% 34.01651 -118.11375
## 550 Lodi 10.1% 38.13415 -121.27222
## 551 New Braunfels 64.0% 29.70300 -98.12445
## 552 Marysville 115.7% 48.05176 -122.17708
## 553 Tamarac 12.9% 26.21286 -80.24977
## 554 Madera 44.4% 36.96134 -120.06072
## 555 Conroe 61.9% 30.31188 -95.45605
## 556 Santa Cruz 12.5% 36.97412 -122.03080
## 557 Eden Prairie 13.3% 44.85469 -93.47079
## 558 Cheyenne 16.9% 41.13998 -104.82025
## 559 Daytona Beach -2.3% 29.21081 -81.02283
## 560 Alpharetta 33.6% 34.07538 -84.29409
## 561 Hamilton 2.7% 39.39950 -84.56134
## 562 Waltham 5.0% 42.37649 -71.23561
## 563 Coon Rapids 0.6% 45.17324 -93.30301
## 564 Haverhill 5.0% 42.77620 -71.07728
## 565 Council Bluffs 6.2% 41.26194 -95.86083
## 566 Taylor -6.3% 42.24087 -83.26965
## 567 Utica 2.2% 43.10090 -75.23266
## 568 Ames 21.3% 42.03472 -93.62000
## 569 La Habra 3.6% 33.93196 -117.94617
## 570 Encinitas 5.8% 33.03699 -117.29198
## 571 Bowling Green 24.1% 36.96852 -86.48080
## 572 Burnsville 1.9% 44.76774 -93.27772
## 573 Greenville 8.2% 34.85262 -82.39401
## 574 West Des Moines 29.8% 41.57721 -93.71133
## 575 Cedar Park 134.3% 30.50520 -97.82029
## 576 Tulare 33.3% 36.20773 -119.34734
## 577 Monterey Park 1.5% 34.06251 -118.12285
## 578 Vineland 9.3% 39.48638 -75.02596
## 579 Terre Haute 2.5% 39.46670 -87.41391
## 580 North Miami 2.0% 25.89009 -80.18671
## 581 Mansfield 114.2% 32.56319 -97.14168
## 582 West Allis -0.6% 43.01668 -88.00703
## 583 Bristol 0.4% 41.67176 -72.94927
## 584 Taylorsville 2.9% 40.66772 -111.93883
## 585 Malden 7.4% 42.42510 -71.06616
## 586 Meriden 3.7% 41.53815 -72.80704
## 587 Blaine 32.8% 45.16080 -93.23495
## 588 Wellington 55.0% 26.66176 -80.26836
## 589 Cupertino 14.3% 37.32300 -122.03218
## 590 Springfield 12.4% 44.04624 -123.02203
## 591 Rogers 50.6% 36.33202 -94.11854
## 592 St. Clair Shores -4.6% 42.49741 -82.89636
## 593 Gardena 3.4% 33.88835 -118.30896
## 594 Pontiac -11.4% 42.63892 -83.29105
## 595 National City 10.1% 32.67811 -117.09920
## 596 Grand Junction 30.9% 39.06387 -108.55065
## 597 Rocklin 60.3% 38.79073 -121.23578
## 598 Chapel Hill 24.1% 35.91320 -79.05584
## 599 Casper 19.9% 42.86663 -106.31308
## 600 Broomfield 50.3% 39.92054 -105.08665
## 601 Petaluma 8.4% 38.23242 -122.63665
## 602 South Jordan 100.1% 40.56217 -111.92966
## 603 Springfield -9.8% 39.92423 -83.80882
## 604 Great Falls 3.9% 47.49418 -111.28334
## 605 Lancaster 4.5% 40.03788 -76.30551
## 606 North Port 154.6% 27.04422 -82.23593
## 607 Lakewood 1.1% 47.17176 -122.51846
## 608 Marietta -3.8% 33.95260 -84.54993
## 609 San Rafael 5.0% 37.97353 -122.53109
## 610 Royal Oak -1.7% 42.48948 -83.14465
## 611 Des Plaines 3.2% 42.03336 -87.88340
## 612 Huntington Park -4.1% 33.98168 -118.22507
## 613 La Mesa 6.9% 32.76783 -117.02308
## 614 Orland Park 13.9% 41.63031 -87.85394
## 615 Auburn 26.4% 32.60986 -85.48078
## 616 Lakeville 34.3% 44.64969 -93.24272
## 617 Owensboro 7.7% 37.77191 -87.11117
## 618 Moore 41.5% 35.33951 -97.48670
## 619 Jupiter 46.2% 26.93422 -80.09421
## 620 Idaho Falls 14.0% 43.49165 -112.03396
## 621 Dubuque 0.9% 42.50056 -90.66457
## 622 Bartlett 31.7% 35.20453 -89.87398
## 623 Rowlett 28.6% 32.90290 -96.56388
## 624 Novi 22.0% 42.48059 -83.47549
## 625 White Plains 8.5% 41.03399 -73.76291
## 626 Arcadia 8.3% 34.13973 -118.03534
## 627 Redmond 26.0% 47.67399 -122.12151
## 628 Lake Elsinore 96.5% 33.66808 -117.32726
## 629 Ocala 20.8% 29.18720 -82.14009
## 630 Tinley Park 16.3% 41.57314 -87.79329
## 631 Port Orange 22.8% 29.13832 -80.99561
## 632 Medford 2.7% 42.41843 -71.10616
## 633 Oak Lawn 3.3% 41.71998 -87.74795
## 634 Rocky Mount -3.1% 35.93821 -77.79053
## 635 Kokomo 21.3% 40.48643 -86.13360
## 636 Coconut Creek 28.4% 26.25175 -80.17894
## 637 Bowie 8.6% 39.00678 -76.77914
## 638 Berwyn 5.1% 41.85059 -87.79367
## 639 Midwest City 4.5% 35.44951 -97.39670
## 640 Fountain Valley 3.0% 33.70918 -117.95367
## 641 Buckeye 480.9% 33.37032 -112.58378
## 642 Dearborn Heights -3.0% 42.33698 -83.27326
## 643 Woodland 13.8% 38.67852 -121.77330
## 644 Noblesville 88.1% 40.04559 -86.00860
## 645 Valdosta 22.3% 30.83270 -83.27849
## 646 Diamond Bar 0.1% 34.02862 -117.81034
## 647 Manhattan 22.8% 39.18361 -96.57167
## 648 Santee 5.7% 32.83838 -116.97392
## 649 Taunton 0.0% 41.90010 -71.08977
## 650 Sanford 42.8% 28.80286 -81.26945
## 651 Kettering -3.1% 39.68950 -84.16883
## 652 New Brunswick 15.5% 40.48622 -74.45182
## 653 Decatur 3.1% 34.60593 -86.98334
## 654 Chicopee 1.7% 42.14870 -72.60787
## 655 Anderson -6.6% 40.10532 -85.68025
## 656 Margate 2.7% 26.24453 -80.20644
## 657 Weymouth Town 42.21807 -70.94104
## 658 Hempstead 4.0% 40.70621 -73.61874
## 659 Corvallis 11.8% 44.56457 -123.26204
## 660 Eastvale 33.95246 -117.58480
## 661 Porterville 20.1% 36.06523 -119.01677
## 662 West Haven 5.1% 41.27055 -72.94697
## 663 Brentwood 122.3% 37.93187 -121.69579
## 664 Paramount -0.7% 33.88946 -118.15979
## 665 Grand Forks 11.5% 47.92526 -97.03285
## 666 Georgetown 91.9% 30.63326 -97.67798
## 667 St. Peters 6.5% 38.78747 -90.62989
## 668 Shoreline 2.9% 47.75565 -122.34152
## 669 Mount Prospect -2.5% 42.06642 -87.93729
## 670 Hanford 30.3% 36.32745 -119.64568
## 671 Normal 19.7% 40.51420 -88.99063
## 672 Rosemead 1.7% 34.08057 -118.07285
## 673 Lehi 176.3% 40.39162 -111.85077
## 674 Pocatello 5.4% 42.87130 -112.44553
## 675 Highland 21.0% 34.12834 -117.20865
## 676 Novato 13.3% 38.10742 -122.56970
## 677 Port Arthur -6.0% 29.88495 -93.93995
## 678 Carson City 2.9% 39.16380 -119.76740
## 679 San Marcos 48.5% 29.88327 -97.94139
## 680 Hendersonville 31.7% 36.30477 -86.62000
## 681 Elyria -3.7% 41.36838 -82.10765
## 682 Revere 13.4% 42.40843 -71.01199
## 683 Pflugerville 123.4% 30.43937 -97.62000
## 684 Greenwood 46.0% 39.61366 -86.10665
## 685 Bellevue 20.5% 41.15436 -95.91456
## 686 Wheaton -3.4% 41.86614 -88.10701
## 687 Smyrna 20.0% 33.88399 -84.51438
## 688 Sarasota 1.4% 27.33643 -82.53065
## 689 Blue Springs 9.9% 39.01695 -94.28161
## 690 Colton 10.8% 34.07390 -117.31365
## 691 Euless 15.1% 32.83707 -97.08195
## 692 Castle Rock 153.5% 39.37221 -104.85609
## 693 Cathedral City 23.2% 33.78054 -116.46680
## 694 Kingsport 16.7% 36.54843 -82.56182
## 695 Lake Havasu City 24.6% 34.48390 -114.32245
## 696 Pensacola -6.0% 30.42131 -87.21691
## 697 Hoboken 35.8% 40.74399 -74.03236
## 698 Yucaipa 26.8% 34.03363 -117.04309
## 699 Watsonville 12.7% 36.91023 -121.75689
## 700 Richland 34.6% 46.28569 -119.28446
## 701 Delano 31.8% 35.76884 -119.24705
## 702 Hoffman Estates 5.4% 42.06299 -88.12272
## 703 Florissant -2.8% 38.78922 -90.32261
## 704 Placentia 11.8% 33.87224 -117.87034
## 705 West New York 13.3% 40.78788 -74.01431
## 706 Dublin 70.0% 37.70215 -121.93579
## 707 Oak Park -0.8% 41.88503 -87.78450
## 708 Peabody 7.5% 42.52787 -70.92866
## 709 Perth Amboy 9.7% 40.50677 -74.26542
## 710 Battle Creek -2.8% 42.32115 -85.17971
## 711 Bradenton 3.4% 27.49893 -82.57482
## 712 Gilroy 23.9% 37.00578 -121.56828
## 713 Milford 1.8% 41.23070 -73.06404
## 714 Albany 25.5% 44.63651 -123.10593
## 715 Ankeny 86.9% 41.73179 -93.60013
## 716 La Crosse -0.8% 43.80136 -91.23958
## 717 Burlington 12.1% 36.09569 -79.43780
## 718 DeSoto 36.0% 32.58970 -96.85707
## 719 Harrisonburg 27.1% 38.44957 -78.86892
## 720 Minnetonka 0.4% 44.92118 -93.46875
## 721 Elkhart -2.5% 41.68199 -85.97667
## 722 Lakewood -9.4% 41.48199 -81.79819
## 723 Glendora 3.1% 34.13612 -117.86534
## 724 Southaven 72.8% 34.98898 -90.01259
## 725 Charleston -4.7% 38.34982 -81.63262
## 726 Joplin 11.2% 37.08423 -94.51328
## 727 Enid 8.1% 36.39559 -97.87839
## 728 Palm Beach Gardens 39.6% 26.82339 -80.13865
## 729 Brookhaven 33.86510 -84.33659
## 730 Plainfield 5.7% 40.63371 -74.40737
## 731 Grand Island 16.0% 40.92640 -98.34201
## 732 Palm Desert 13.2% 33.72224 -116.37446
## 733 Huntersville 92.9% 35.41069 -80.84285
## 734 Tigard 17.8% 45.43123 -122.77149
## 735 Lenexa 24.6% 38.95362 -94.73357
## 736 Saginaw -18.2% 43.41947 -83.95081
## 737 Kentwood 10.5% 42.86947 -85.64475
## 738 Doral 137.6% 25.81954 -80.35533
## 739 Apple Valley 9.2% 44.73191 -93.21772
## 740 Grapevine 17.6% 32.93429 -97.07807
## 741 Aliso Viejo 25.4% 33.56768 -117.72561
## 742 Sammamish 44.1% 47.61627 -122.03557
## 743 Casa Grande 86.0% 32.87950 -111.75735
## 744 Pinellas Park 5.9% 27.84280 -82.69954
## 745 Troy 1.5% 42.72841 -73.69179
## 746 West Sacramento 55.6% 38.58046 -121.53023
## 747 Burien 56.7% 47.47038 -122.34679
## 748 Commerce City 135.4% 39.80832 -104.93387
## 749 Monroe -6.1% 32.50931 -92.11930
## 750 Cerritos -3.6% 33.85835 -118.06479
## 751 Downers Grove 0.0% 41.80892 -88.01117
## 752 Coral Gables 16.1% 25.72149 -80.26838
## 753 Wilson 10.1% 35.72127 -77.91554
## 754 Niagara Falls -10.8% 43.09621 -79.03774
## 755 Poway 2.4% 32.96282 -117.03586
## 756 Edina 4.1% 44.88969 -93.34995
## 757 Cuyahoga Falls -0.2% 41.13394 -81.48456
## 758 Rancho Santa Margarita 4.6% 33.64086 -117.60310
## 759 Harrisburg 0.6% 40.27319 -76.88670
## 760 Huntington -5.0% 38.41925 -82.44515
## 761 La Mirada 4.6% 33.91724 -118.01201
## 762 Cypress 5.3% 33.81696 -118.03729
## 763 Caldwell 77.1% 43.66294 -116.68736
## 764 Logan 14.5% 41.73698 -111.83384
## 765 Galveston -15.2% 29.30135 -94.79770
## 766 Sheboygan -3.9% 43.75083 -87.71453
## 767 Middletown -5.7% 39.51506 -84.39828
## 768 Murray 6.6% 40.66689 -111.88799
## 769 Roswell 7.5% 33.39427 -104.52302
## 770 Parker 96.4% 39.51860 -104.76136
## 771 Bedford 2.9% 32.84402 -97.14307
## 772 East Lansing 4.2% 42.73698 -84.48387
## 773 Methuen 10.3% 42.72620 -71.19089
## 774 Covina 3.3% 34.09001 -117.89034
## 775 Alexandria 4.1% 31.31129 -92.44514
## 776 Olympia 12.1% 47.03787 -122.90070
## 777 Euclid -8.4% 41.59310 -81.52679
## 778 Mishawaka 2.0% 41.66199 -86.15862
## 779 Salina 4.5% 38.84028 -97.61142
## 780 Azusa 6.7% 34.13362 -117.90756
## 781 Newark 3.1% 40.05812 -82.40126
## 782 Chesterfield 1.9% 38.66311 -90.57707
## 783 Leesburg 66.0% 39.11566 -77.56360
## 784 Dunwoody 33.94621 -84.33465
## 785 Hattiesburg 3.1% 31.32712 -89.29034
## 786 Roseville -1.0% 42.49726 -82.93714
## 787 Bonita Springs 43.8% 26.33981 -81.77870
## 788 Portage 5.7% 42.20115 -85.58000
## 789 St. Louis Park 7.3% 44.95974 -93.37022
## 790 Collierville 43.4% 35.04204 -89.66453
## 791 Middletown 3.6% 41.56232 -72.65065
## 792 Stillwater 20.1% 36.11561 -97.05837
## 793 East Providence -3.3% 41.81371 -71.37005
## 794 Lawrence 20.5% 39.83865 -86.02526
## 795 Wauwatosa 0.0% 43.04946 -88.00759
## 796 Mentor -6.6% 41.66616 -81.33955
## 797 Ceres 34.0% 37.59493 -120.95771
## 798 Cedar Hill 42.4% 32.58847 -96.95612
## 799 Mansfield -10.1% 40.75839 -82.51545
## 800 Binghamton -1.7% 42.09869 -75.91797
## 801 Coeur d'Alene 32.8% 47.67768 -116.78047
## 802 San Luis Obispo 4.4% 35.28275 -120.65962
## 803 Minot 26.6% 48.23297 -101.29229
## 804 Palm Springs 7.7% 33.83030 -116.54529
## 805 Pine Bluff -16.2% 34.22843 -92.00320
## 806 Texas City 10.3% 29.38385 -94.90270
## 807 Summerville 62.9% 33.01850 -80.17565
## 808 Twin Falls 31.5% 42.56297 -114.46087
## 809 Jeffersonville 53.3% 38.27757 -85.73718
## 810 San Jacinto 91.8% 33.78391 -116.95864
## 811 Madison 53.7% 34.69926 -86.74833
## 812 Altoona -7.3% 40.51868 -78.39474
## 813 Columbus 16.4% 39.20144 -85.92138
## 814 Beavercreek 19.0% 39.70923 -84.06327
## 815 Apopka 63.9% 28.69341 -81.53221
## 816 Elmhurst 5.7% 41.89947 -87.94034
## 817 Maricopa 2503.4% 33.05811 -112.04764
## 818 Farmington 18.1% 36.72806 -108.21869
## 819 Glenview 5.2% 42.06975 -87.78784
## 820 Cleveland Heights -10.3% 41.52005 -81.55624
## 821 Draper 77.4% 40.52467 -111.86382
## 822 Lincoln 285.2% 38.89156 -121.29301
## 823 Sierra Vista 19.3% 31.54550 -110.27729
## 824 Lacey 41.7% 47.03426 -122.82319
## 825 Biloxi -11.5% 30.39603 -88.88531
## 826 Strongsville 1.9% 41.31450 -81.83569
## 827 Barnstable Town -7.1% 41.70032 -70.30020
## 828 Wylie 185.2% 33.01512 -96.53888
## 829 Sayreville 9.6% 40.45940 -74.36085
## 830 Kannapolis 18.6% 35.48736 -80.62173
## 831 Charlottesville 10.5% 38.02931 -78.47668
## 832 Littleton 9.4% 39.61332 -105.01665
## 833 Titusville 7.8% 28.61222 -80.80755
## 834 Hackensack 2.9% 40.88593 -74.04347
## 835 Newark 3.3% 37.52966 -122.04024
## 836 Pittsfield -3.6% 42.45008 -73.24538
## 837 York 6.4% 39.96260 -76.72774
## 838 Lombard 2.9% 41.88003 -88.00784
## 839 Attleboro 4.6% 41.94454 -71.28561
## 840 DeKalb 11.8% 41.92947 -88.75036
## 841 Blacksburg 9.4% 37.22957 -80.41394
## 842 Dublin 37.6% 40.09923 -83.11408
## 843 Haltom City 11.4% 32.79957 -97.26918
## 844 Lompoc 5.5% 34.63915 -120.45794
## 845 El Centro 13.7% 32.79200 -115.56305
## 846 Danville 3.7% 37.82159 -121.99996
## 847 Jefferson City 6.7% 38.57670 -92.17352
## 848 Cutler Bay 42.9% 25.58083 -80.34686
## 849 Oakland Park 2.7% 26.17231 -80.13199
## 850 North Miami Beach 3.6% 25.93315 -80.16255
## 851 Freeport -1.4% 40.65760 -73.58318
## 852 Moline -1.9% 41.50670 -90.51513
## 853 Coachella 88.4% 33.68030 -116.17389
## 854 Fort Pierce 6.9% 27.44671 -80.32561
## 855 Smyrna 54.9% 35.98284 -86.51860
## 856 Bountiful 3.9% 40.88939 -111.88077
## 857 Fond du Lac 1.7% 43.77304 -88.44705
## 858 Everett 12.1% 42.40843 -71.05366
## 859 Danville -11.0% 36.58597 -79.39502
## 860 Keller 53.3% 32.93419 -97.22930
## 861 Belleville 1.2% 38.52005 -89.98399
## 862 Bell Gardens -2.7% 33.96529 -118.15146
## 863 Cleveland 14.1% 35.15952 -84.87661
## 864 North Lauderdale 10.8% 26.21730 -80.22588
## 865 Fairfield 1.2% 39.34547 -84.56032
## 866 Salem 5.1% 42.51954 -70.89672
## 867 Rancho Palos Verdes 2.9% 33.74446 -118.38702
## 868 San Bruno 5.6% 37.63049 -122.41108
## 869 Concord 4.1% 43.20814 -71.53757
## 870 Burlington 6.1% 44.47588 -73.21207
## 871 Apex 98.8% 35.73265 -78.85029
## 872 Midland 0.9% 43.61558 -84.24721
## 873 Altamonte Springs 2.0% 28.66111 -81.36562
## 874 Hutchinson 0.1% 38.06084 -97.92977
## 875 Buffalo Grove -3.4% 42.16628 -87.96313
## 876 Urbandale 41.5% 41.62666 -93.71217
## 877 State College 8.7% 40.79339 -77.86000
## 878 Urbana 10.3% 40.11059 -88.20727
## 879 Plainfield 203.6% 41.63222 -88.21203
## 880 Manassas 19.5% 38.75095 -77.47527
## 881 Bartlett 13.1% 41.99503 -88.18563
## 882 Kearny 2.8% 40.76843 -74.14542
## 883 Oro Valley 27.0% 32.39091 -110.96649
## 884 Findlay 5.8% 41.04422 -83.64993
## 885 Rohnert Park 0.0% 38.33964 -122.70110
## 886 Westfield 3.0% 42.12509 -72.74954
## 887 Linden 4.7% 40.62205 -74.24459
## 888 Sumter 1.3% 33.92044 -80.34147
## 889 Wilkes-Barre -4.3% 41.24591 -75.88131
## 890 Woonsocket -5.2% 42.00288 -71.51478
## 891 Leominster -1.1% 42.52509 -71.75979
## 892 Shelton 7.3% 41.31649 -73.09316
## 893 Brea 15.2% 33.91668 -117.90006
## 894 Covington -4.7% 39.08367 -84.50855
## 895 Rockwall 117.2% 32.93123 -96.45971
## 896 Meridian -0.9% 32.36431 -88.70366
## 897 Riverton 61.6% 40.52189 -111.93910
## 898 St. Cloud 86.2% 28.24890 -81.28118
## 899 Quincy 0.5% 39.93560 -91.40987
## 900 Morgan Hill 19.5% 37.13050 -121.65439
## 901 Warren -15.2% 41.23756 -80.81842
## 902 Edmonds 2.9% 47.81065 -122.37736
## 903 Burleson 85.3% 32.54208 -97.32085
## 904 Beverly 2.0% 42.55843 -70.88005
## 905 Mankato 24.7% 44.16358 -93.99940
## 906 Hagerstown 10.4% 39.64176 -77.71999
## 907 Prescott 18.1% 34.54002 -112.46850
## 908 Campbell 4.2% 37.28717 -121.94996
## 909 Cedar Falls 12.0% 42.53490 -92.44532
## 910 Beaumont 254.5% 33.92946 -116.97725
## 911 La Puente -1.6% 34.02001 -117.94951
## 912 Crystal Lake 5.3% 42.24113 -88.31620
## 913 Fitchburg 3.5% 42.58342 -71.80230
## 914 Carol Stream -0.2% 41.91253 -88.13479
## 915 Hickory 7.0% 35.73445 -81.34446
## 916 Streamwood 10.1% 42.02558 -88.17841
## 917 Norwich 11.6% 41.52426 -72.07591
## 918 Coppell 10.3% 32.95457 -97.01501
## 919 San Gabriel 0.9% 34.09611 -118.10583
## 920 Holyoke 0.9% 42.20426 -72.61620
## 921 Bentonville 97.7% 36.37285 -94.20882
## 922 Florence 10.2% 34.79981 -87.67725
## 923 Peachtree Corners 33.96989 -84.22146
## 924 Brentwood 51.9% 36.03312 -86.78278
## 925 Bozeman 41.9% 45.67700 -111.04293
## 926 New Berlin 3.6% 42.97640 -88.10842
## 927 Goose Creek 26.1% 32.98101 -80.03259
## 928 Huntsville 13.2% 30.72353 -95.55078
## 929 Prescott Valley 62.9% 34.61002 -112.31572
## 930 Maplewood 12.3% 44.95302 -92.99522
## 931 Romeoville 79.5% 41.64753 -88.08951
## 932 Duncanville 9.7% 32.65180 -96.90834
## 933 Atlantic City -2.2% 39.36428 -74.42293
## 934 Clovis 21.3% 34.40480 -103.20523
## 935 The Colony 45.7% 33.08061 -96.89283
## 936 Culver City 1.3% 34.02112 -118.39647
## 937 Marlborough 7.6% 42.34593 -71.55229
## 938 Hilton Head Island 16.0% 32.21632 -80.75261
## 939 Moorhead 21.3% 46.87376 -96.76780
## 940 Calexico 44.0% 32.67895 -115.49888
## 941 Bullhead City 15.9% 35.13594 -114.52860
## 942 Germantown 4.1% 35.08676 -89.81009
## 943 La Quinta 59.9% 33.66336 -116.31001
## 944 Lancaster 10.7% 39.71368 -82.59933
## 945 Wausau 1.7% 44.95914 -89.63012
## 946 Sherman 11.6% 33.63566 -96.60888
## 947 Ocoee 57.9% 28.56917 -81.54396
## 948 Shakopee 85.7% 44.79740 -93.52729
## 949 Woburn 4.4% 42.47926 -71.15228
## 950 Bremerton 4.9% 47.56732 -122.63294
## 951 Rock Island -1.9% 41.50948 -90.57875
## 952 Muskogee -0.7% 35.74788 -95.36969
## 953 Cape Girardeau 9.4% 37.30588 -89.51815
## 954 Annapolis 7.6% 38.97845 -76.49218
## 955 Greenacres 35.5% 26.62763 -80.13539
## 956 Ormond Beach 5.8% 29.28581 -81.05589
## 957 Hallandale Beach 12.4% 25.98120 -80.14838
## 958 Stanton 2.8% 33.80252 -117.99312
## 959 Puyallup 11.8% 47.18538 -122.29290
## 960 Pacifica 0.5% 37.61383 -122.48692
## 961 Hanover Park 0.6% 41.99947 -88.14507
## 962 Hurst 5.8% 32.82346 -97.17057
## 963 Lima -8.1% 40.74255 -84.10523
## 964 Marana 166.2% 32.43638 -111.22244
## 965 Carpentersville 22.8% 42.12114 -88.25786
## 966 Oakley 47.7% 37.99742 -121.71245
## 967 Huber Heights -0.2% 39.84395 -84.12466
## 968 Lancaster 46.4% 32.59208 -96.75611
## 969 Montclair 12.1% 34.07751 -117.68978
## 970 Wheeling 4.8% 42.13919 -87.92896
## 971 Brookfield -1.9% 43.06057 -88.10648
## 972 Park Ridge 0.1% 42.01114 -87.84062
## 973 Florence 19.8% 34.19543 -79.76256
## 974 Roy 13.3% 41.16161 -112.02633
## 975 Winter Garden 142.5% 28.56528 -81.58618
## 976 Chelsea 7.3% 42.39176 -71.03283
## 977 Valley Stream 3.6% 40.66427 -73.70846
## 978 Spartanburg -6.2% 34.94957 -81.93205
## 979 Lake Oswego 5.3% 45.42067 -122.67065
## 980 Friendswood 28.6% 29.52940 -95.20104
## 981 Westerville 5.7% 40.12617 -82.92907
## 982 Northglenn 15.5% 39.89618 -104.98115
## 983 Phenix City 31.9% 32.47098 -85.00077
## 984 Grove City 35.6% 39.88145 -83.09296
## 985 Texarkana 7.4% 33.42513 -94.04769
## 986 Addison 2.6% 41.93170 -87.98896
## 987 Dover 16.0% 39.15817 -75.52437
## 988 Lincoln Park -6.7% 42.25059 -83.17854
## 989 Calumet City -4.5% 41.61559 -87.52949
## 990 Muskegon -7.1% 43.23418 -86.24839
## 991 Aventura 47.2% 25.95648 -80.13921
## 992 Martinez 3.4% 38.01937 -122.13413
## 993 Greenfield 4.8% 42.96140 -88.01259
## 994 Apache Junction 15.7% 33.41505 -111.54958
## 995 Monrovia 0.2% 34.14426 -118.00195
## 996 Weslaco 28.8% 26.15952 -97.99084
## 997 Keizer 14.4% 44.99012 -123.02621
## 998 Spanish Fork 78.1% 40.11496 -111.65492
## 999 Beloit 2.9% 42.50835 -89.03178
## 1000 Panama City 0.1% 30.15881 -85.66021
## population rank state
## 1 8405837 1 New York
## 2 3884307 2 California
## 3 2718782 3 Illinois
## 4 2195914 4 Texas
## 5 1553165 5 Pennsylvania
## 6 1513367 6 Arizona
## 7 1409019 7 Texas
## 8 1355896 8 California
## 9 1257676 9 Texas
## 10 998537 10 California
## 11 885400 11 Texas
## 12 843393 12 Indiana
## 13 842583 13 Florida
## 14 837442 14 California
## 15 822553 15 Ohio
## 16 792862 16 North Carolina
## 17 792727 17 Texas
## 18 688701 18 Michigan
## 19 674433 19 Texas
## 20 653450 20 Tennessee
## 21 652405 21 Washington
## 22 649495 22 Colorado
## 23 646449 23 District of Columbia
## 24 645966 24 Massachusetts
## 25 634464 25 Tennessee
## 26 622104 26 Maryland
## 27 610613 27 Oklahoma
## 28 609893 28 Kentucky
## 29 609456 29 Oregon
## 30 603488 30 Nevada
## 31 599164 31 Wisconsin
## 32 556495 32 New Mexico
## 33 526116 33 Arizona
## 34 509924 34 California
## 35 479686 35 California
## 36 469428 36 California
## 37 467007 37 Missouri
## 38 457587 38 Arizona
## 39 448479 39 Virginia
## 40 447841 40 Georgia
## 41 439886 41 Colorado
## 42 434353 42 Nebraska
## 43 431746 43 North Carolina
## 44 417650 44 Florida
## 45 406253 45 California
## 46 400070 46 Minnesota
## 47 398121 47 Oklahoma
## 48 390113 48 Ohio
## 49 386552 49 Kansas
## 50 379577 50 Texas
## 51 378715 51 Louisiana
## 52 363630 52 California
## 53 352957 53 Florida
## 54 347884 54 Hawaii
## 55 345803 55 Colorado
## 56 345012 56 California
## 57 334227 57 California
## 58 318416 58 Missouri
## 59 316619 59 California
## 60 316381 60 Texas
## 61 308428 61 Kentucky
## 62 305841 62 Pennsylvania
## 63 300950 63 Alaska
## 64 298118 64 California
## 65 297517 65 Ohio
## 66 294873 66 Minnesota
## 67 282313 67 Ohio
## 68 279639 68 North Carolina
## 69 278427 69 New Jersey
## 70 274409 70 Texas
## 71 270811 71 Nevada
## 72 268738 72 Nebraska
## 73 258959 73 New York
## 74 257342 74 New Jersey
## 75 256780 75 California
## 76 256496 76 Indiana
## 77 255483 77 Florida
## 78 249688 78 Florida
## 79 249146 79 Arizona
## 80 248142 80 Texas
## 81 246139 81 Virginia
## 82 245475 82 North Carolina
## 83 243344 83 Wisconsin
## 84 239538 84 Texas
## 85 236716 85 California
## 86 236441 86 North Carolina
## 87 234632 87 Arizona
## 88 234566 88 Texas
## 89 233394 89 Florida
## 90 233294 90 Nevada
## 91 230571 91 Virginia
## 92 229972 92 Arizona
## 93 229426 93 Louisiana
## 94 228653 94 Texas
## 95 226918 95 Arizona
## 96 226877 96 Nevada
## 97 224922 97 California
## 98 214237 98 Idaho
## 99 214114 99 Virginia
## 100 213708 100 California
## 101 212113 101 Alabama
## 102 210721 102 Washington
## 103 210358 103 New York
## 104 207510 104 Iowa
## 105 204933 105 California
## 106 204408 106 North Carolina
## 107 203446 107 Washington
## 108 203007 108 California
## 109 203003 109 California
## 110 202824 110 Georgia
## 111 201332 111 Alabama
## 112 201175 112 California
## 113 200327 113 Louisiana
## 114 199963 114 Illinois
## 115 199766 115 New York
## 116 198100 116 Ohio
## 117 197575 117 California
## 118 197357 118 Arkansas
## 119 197350 119 Georgia
## 120 196429 120 Texas
## 121 196021 121 California
## 122 194899 122 Alabama
## 123 192294 123 Michigan
## 124 191180 124 Utah
## 125 186411 125 Florida
## 126 186254 126 Alabama
## 127 183372 127 Texas
## 128 183270 128 Tennessee
## 129 182544 129 Massachusetts
## 130 182020 130 Virginia
## 131 181860 131 Texas
## 132 181260 132 Kansas
## 133 179590 133 California
## 134 177994 134 Rhode Island
## 135 175140 135 California
## 136 173366 136 Tennessee
## 137 172794 137 California
## 138 172638 138 Mississippi
## 139 172389 139 Florida
## 140 171990 140 California
## 141 171386 141 California
## 142 171016 142 Florida
## 143 168228 143 Arizona
## 144 167500 144 California
## 145 167405 145 Washington
## 146 165831 146 Florida
## 147 164676 147 South Dakota
## 148 164122 148 Missouri
## 149 162592 149 Arizona
## 150 162329 150 Florida
## 151 161007 151 California
## 152 160614 152 Oregon
## 153 159523 153 California
## 154 159503 154 California
## 155 159190 155 Oregon
## 156 157161 156 California
## 157 155662 157 California
## 158 153703 158 Massachusetts
## 159 152735 159 Texas
## 160 152061 160 Colorado
## 161 151574 161 California
## 162 151348 162 California
## 163 151088 163 North Carolina
## 164 150251 164 Illinois
## 165 148892 165 Virginia
## 166 148738 166 California
## 167 148559 167 Texas
## 168 148483 168 Kansas
## 169 147806 169 Illinois
## 170 147559 170 California
## 171 147478 171 California
## 172 147216 172 Connecticut
## 173 147214 173 Colorado
## 174 146526 174 Florida
## 175 145948 175 New Jersey
## 176 144864 176 Illinois
## 177 144669 177 New York
## 178 143484 178 Texas
## 179 143355 179 Ohio
## 180 142772 180 Georgia
## 181 142357 181 Tennessee
## 182 139969 182 California
## 183 139731 183 California
## 184 138981 184 California
## 185 137147 185 Texas
## 186 136791 186 Texas
## 187 136699 187 Virginia
## 188 136639 188 Texas
## 189 134873 189 Michigan
## 190 133992 190 Washington
## 191 133579 191 Utah
## 192 133358 192 South Carolina
## 193 131885 193 Kansas
## 194 131224 194 Michigan
## 195 130660 195 Connecticut
## 196 130288 196 Florida
## 197 129030 197 Texas
## 198 128731 198 California
## 199 128429 199 Iowa
## 200 127999 200 South Carolina
## 201 127763 201 California
## 202 127679 202 Kansas
## 203 127558 203 New Jersey
## 204 127488 204 Florida
## 205 127359 205 Colorado
## 206 127035 206 California
## 207 126700 207 Texas
## 208 126604 208 Florida
## 209 126456 209 Connecticut
## 210 126181 210 California
## 211 125880 211 California
## 212 125017 212 Connecticut
## 213 124435 213 Washington
## 214 124276 214 Louisiana
## 215 123933 215 Texas
## 216 123546 216 Arizona
## 217 123099 217 Texas
## 218 121096 218 California
## 219 120310 219 Indiana
## 220 120245 220 California
## 221 120099 221 Texas
## 222 119980 222 Georgia
## 223 118837 223 California
## 224 118577 224 Pennsylvania
## 225 118197 225 Oklahoma
## 226 117796 226 Texas
## 227 117240 227 Missouri
## 228 117044 228 Tennessee
## 229 117025 229 Michigan
## 230 117006 230 Illinois
## 231 116768 231 California
## 232 116513 232 Illinois
## 233 116288 233 Utah
## 234 115708 234 California
## 235 115276 235 Missouri
## 236 113972 236 Michigan
## 237 113658 237 North Dakota
## 238 113242 238 California
## 239 112174 239 California
## 240 112067 240 North Carolina
## 241 111707 241 Colorado
## 242 111542 242 California
## 243 111378 243 Florida
## 244 110972 244 California
## 245 110945 245 Colorado
## 246 110742 246 Minnesota
## 247 110720 247 Texas
## 248 110378 248 New Hampshire
## 249 110145 249 Illinois
## 250 110077 250 Utah
## 251 109821 251 Texas
## 252 109703 252 Florida
## 253 109676 253 Connecticut
## 254 109397 254 Oregon
## 255 109320 255 California
## 256 109059 256 Montana
## 257 108861 257 Massachusetts
## 258 108817 258 California
## 259 108249 259 Colorado
## 260 107741 260 North Carolina
## 261 107740 261 California
## 262 107571 262 California
## 263 107479 263 California
## 264 107289 264 Massachusetts
## 265 107100 265 California
## 266 106780 266 California
## 267 106589 267 California
## 268 106114 268 Colorado
## 269 105370 269 Washington
## 270 104898 270 Florida
## 271 104898 271 Texas
## 272 104779 272 Wisconsin
## 273 104739 273 California
## 274 104709 274 California
## 275 104475 275 Texas
## 276 104410 276 Florida
## 277 104054 277 South Carolina
## 278 103500 278 Oklahoma
## 279 103166 279 Colorado
## 280 102436 280 Florida
## 281 102216 281 California
## 282 102211 282 California
## 283 102157 283 Iowa
## 284 101910 284 California
## 285 101324 285 New Mexico
## 286 101128 286 California
## 287 101074 287 Texas
## 288 100886 288 Indiana
## 289 100710 289 Florida
## 290 100671 290 Pennsylvania
## 291 100223 291 Texas
## 292 100065 292 Texas
## 293 100050 293 Texas
## 294 99889 294 Wisconsin
## 295 99770 295 Georgia
## 296 99769 296 California
## 297 99763 297 Michigan
## 298 98465 298 Virginia
## 299 98424 299 New York
## 300 98030 300 California
## 301 97877 301 California
## 302 97492 302 Texas
## 303 97368 303 Oregon
## 304 97151 304 Oklahoma
## 305 97003 305 Washington
## 306 96929 306 California
## 307 96830 307 Florida
## 308 96539 308 Colorado
## 309 96346 309 California
## 310 96205 310 Virginia
## 311 95884 311 Michigan
## 312 95677 312 California
## 313 95334 313 Alabama
## 314 95208 314 Michigan
## 315 95078 315 Massachusetts
## 316 94275 316 California
## 317 94089 317 Massachusetts
## 318 94034 318 Georgia
## 319 93542 319 Oregon
## 320 93494 320 Massachusetts
## 321 93282 321 Nevada
## 322 93257 322 Washington
## 323 93184 323 Missouri
## 324 92734 324 Washington
## 325 92599 325 California
## 326 92472 326 California
## 327 92147 327 California
## 328 92020 328 Texas
## 329 91956 329 New Mexico
## 330 91923 330 Arizona
## 331 91739 331 California
## 332 91648 332 Utah
## 333 91589 333 Massachusetts
## 334 91119 334 California
## 335 91113 335 Washington
## 336 91026 336 Florida
## 337 90983 337 Texas
## 338 90811 338 Kansas
## 339 90412 339 California
## 340 90268 340 Florida
## 341 90231 341 Utah
## 342 90116 342 Florida
## 343 89981 343 Georgia
## 344 89919 344 Colorado
## 345 89407 345 Florida
## 346 89387 346 California
## 347 89130 347 North Carolina
## 348 88826 348 Illinois
## 349 88697 349 Massachusetts
## 350 88077 350 California
## 351 87971 351 Massachusetts
## 352 87965 352 California
## 353 87893 353 Pennsylvania
## 354 87776 354 Connecticut
## 355 87650 355 Arkansas
## 356 87273 356 California
## 357 87236 357 North Carolina
## 358 87137 358 New Hampshire
## 359 87004 359 Oklahoma
## 360 86635 360 California
## 361 86518 361 Idaho
## 362 86319 362 Minnesota
## 363 86290 363 Florida
## 364 86199 364 California
## 365 86128 365 Minnesota
## 366 85927 366 Indiana
## 367 85728 367 Virginia
## 368 85390 368 New Jersey
## 369 85285 369 California
## 370 85156 370 California
## 371 84691 371 California
## 372 84577 372 California
## 373 84430 373 Washington
## 374 84349 374 New Jersey
## 375 84249 375 Utah
## 376 84126 376 Alabama
## 377 84103 377 Illinois
## 378 83891 378 Indiana
## 379 83860 379 Texas
## 380 83684 380 Connecticut
## 381 83596 381 Idaho
## 382 83539 382 California
## 383 83506 383 North Carolina
## 384 83447 384 California
## 385 83424 385 Illinois
## 386 82882 386 California
## 387 82821 387 Michigan
## 388 82809 388 Missouri
## 389 82788 389 Georgia
## 390 82631 390 Washington
## 391 82578 391 Michigan
## 392 82575 392 Indiana
## 393 82459 393 Iowa
## 394 81971 394 Rhode Island
## 395 81750 395 California
## 396 81443 396 Texas
## 397 81295 397 Michigan
## 398 81236 398 Oregon
## 399 81121 399 California
## 400 81102 400 California
## 401 81050 401 Texas
## 402 80988 402 California
## 403 80872 403 California
## 404 80836 404 Texas
## 405 80566 405 Rhode Island
## 406 80429 406 Ohio
## 407 79446 407 New York
## 408 79312 408 California
## 409 79068 409 California
## 410 78967 410 Indiana
## 411 78960 411 Arkansas
## 412 78902 412 Illinois
## 413 78822 413 Arizona
## 414 78804 414 Massachusetts
## 415 78740 415 Florida
## 416 78709 416 Texas
## 417 78450 417 Indiana
## 418 78409 418 Florida
## 419 78373 419 Minnesota
## 420 78327 420 California
## 421 78199 421 Wisconsin
## 422 78041 422 Florida
## 423 78014 423 Virginia
## 424 77846 424 California
## 425 77677 425 Oregon
## 426 77657 426 Massachusetts
## 427 77593 427 California
## 428 77508 428 Florida
## 429 77147 429 Missouri
## 430 76903 430 New Jersey
## 431 76817 431 Utah
## 432 76762 432 Washington
## 433 76635 433 California
## 434 76572 434 California
## 435 76419 435 California
## 436 76185 436 Georgia
## 437 75994 437 Illinois
## 438 75806 438 Pennsylvania
## 439 75570 439 Illinois
## 440 75548 440 Michigan
## 441 75418 441 Texas
## 442 75413 442 California
## 443 75229 443 Arkansas
## 444 75018 444 Pennsylvania
## 445 74907 445 Illinois
## 446 74885 446 South Carolina
## 447 74860 447 Washington
## 448 74710 448 Illinois
## 449 74513 449 California
## 450 74110 450 California
## 451 74100 451 Michigan
## 452 74024 452 Louisiana
## 453 73987 453 Minnesota
## 454 73936 454 Illinois
## 455 73790 455 Texas
## 456 73596 456 Wisconsin
## 457 73209 457 North Carolina
## 458 73098 458 California
## 459 73006 459 Michigan
## 460 72952 460 Michigan
## 461 72939 461 Connecticut
## 462 72864 462 Arizona
## 463 72535 463 Ohio
## 464 72531 464 Georgia
## 465 72528 465 California
## 466 72326 466 California
## 467 71948 467 California
## 468 71591 468 Iowa
## 469 71551 469 Arkansas
## 470 71525 470 Delaware
## 471 71371 471 California
## 472 71334 472 Colorado
## 473 71172 473 Rhode Island
## 474 71097 474 Florida
## 475 71016 475 Wisconsin
## 476 71012 476 Mississippi
## 477 70924 477 California
## 478 70868 478 New Jersey
## 479 70812 479 South Dakota
## 480 70790 480 Utah
## 481 70373 481 Indiana
## 482 70365 482 California
## 483 70316 483 Indiana
## 484 70190 484 Texas
## 485 70185 485 Texas
## 486 69999 486 California
## 487 69976 487 New Mexico
## 488 69813 488 Florida
## 489 69783 489 California
## 490 69350 490 Illinois
## 491 69122 491 Montana
## 492 69103 492 South Carolina
## 493 69079 493 North Carolina
## 494 68886 494 Tennessee
## 495 68667 495 Arizona
## 496 68609 496 Texas
## 497 68388 497 Florida
## 498 68366 498 Iowa
## 499 68247 499 New Jersey
## 500 68224 500 New York
## 501 68190 501 Florida
## 502 68001 502 Alabama
## 503 67911 503 California
## 504 67815 504 California
## 505 67685 505 Tennessee
## 506 67599 506 Washington
## 507 67569 507 Missouri
## 508 67545 508 Wisconsin
## 509 67317 509 Texas
## 510 67034 510 North Dakota
## 511 67032 511 California
## 512 66975 512 Louisiana
## 513 66900 513 California
## 514 66893 514 Maryland
## 515 66778 515 Wisconsin
## 516 66695 516 California
## 517 66642 517 California
## 518 66333 518 Louisiana
## 519 66318 519 Maine
## 520 66297 520 Minnesota
## 521 66205 521 California
## 522 66174 522 California
## 523 66086 523 California
## 524 66075 524 Arkansas
## 525 65902 525 New York
## 526 65690 526 Maryland
## 527 65665 527 Texas
## 528 65656 528 Minnesota
## 529 65453 529 Minnesota
## 530 65416 530 California
## 531 65415 531 Minnesota
## 532 65184 532 Ohio
## 533 65176 533 Illinois
## 534 65173 534 Florida
## 535 65123 535 Tennessee
## 536 65098 536 Texas
## 537 65040 537 California
## 538 65028 538 New Jersey
## 539 64652 539 California
## 540 64544 540 New Jersey
## 541 64323 541 Kansas
## 542 64079 542 Florida
## 543 64072 544 Maryland
## 544 64072 543 Florida
## 545 63820 545 Wisconsin
## 546 63816 546 Arkansas
## 547 63771 547 California
## 548 63710 548 Ohio
## 549 63495 549 California
## 550 63338 550 California
## 551 63279 551 Texas
## 552 63269 552 Washington
## 553 63155 553 Florida
## 554 63105 554 California
## 555 63032 555 Texas
## 556 62864 556 California
## 557 62603 557 Minnesota
## 558 62448 558 Wyoming
## 559 62316 559 Florida
## 560 62298 560 Georgia
## 561 62258 561 Ohio
## 562 62227 562 Massachusetts
## 563 62103 563 Minnesota
## 564 62088 564 Massachusetts
## 565 61969 565 Iowa
## 566 61817 566 Michigan
## 567 61808 567 New York
## 568 61792 568 Iowa
## 569 61653 569 California
## 570 61588 570 California
## 571 61488 571 Kentucky
## 572 61434 572 Minnesota
## 573 61397 573 South Carolina
## 574 61255 574 Iowa
## 575 61238 575 Texas
## 576 61170 576 California
## 577 61085 577 California
## 578 61050 578 New Jersey
## 579 61025 579 Indiana
## 580 61007 580 Florida
## 581 60872 581 Texas
## 582 60697 582 Wisconsin
## 583 60568 583 Connecticut
## 584 60519 584 Utah
## 585 60509 585 Massachusetts
## 586 60456 586 Connecticut
## 587 60407 587 Minnesota
## 588 60202 588 Florida
## 589 60189 589 California
## 590 60177 590 Oregon
## 591 60112 591 Arkansas
## 592 60070 592 Michigan
## 593 59957 593 California
## 594 59887 594 Michigan
## 595 59834 595 California
## 596 59778 596 Colorado
## 597 59738 597 California
## 598 59635 598 North Carolina
## 599 59628 599 Wyoming
## 600 59471 600 Colorado
## 601 59440 601 California
## 602 59366 602 Utah
## 603 59357 603 Ohio
## 604 59351 604 Montana
## 605 59325 605 Pennsylvania
## 606 59212 606 Florida
## 607 59097 607 Washington
## 608 59089 608 Georgia
## 609 58994 609 California
## 610 58946 610 Michigan
## 611 58918 611 Illinois
## 612 58879 612 California
## 613 58642 613 California
## 614 58590 614 Illinois
## 615 58582 615 Alabama
## 616 58562 616 Minnesota
## 617 58416 617 Kentucky
## 618 58414 618 Oklahoma
## 619 58298 619 Florida
## 620 58292 620 Idaho
## 621 58253 621 Iowa
## 622 58226 622 Tennessee
## 623 58043 623 Texas
## 624 57960 624 Michigan
## 625 57866 625 New York
## 626 57639 626 California
## 627 57530 627 Washington
## 628 57525 628 California
## 629 57468 629 Florida
## 630 57282 630 Illinois
## 631 57203 631 Florida
## 632 57170 632 Massachusetts
## 633 57073 633 Illinois
## 634 56954 634 North Carolina
## 635 56895 635 Indiana
## 636 56792 636 Florida
## 637 56759 637 Maryland
## 638 56758 638 Illinois
## 639 56756 639 Oklahoma
## 640 56707 640 California
## 641 56683 641 Arizona
## 642 56620 642 Michigan
## 643 56590 643 California
## 644 56540 644 Indiana
## 645 56481 645 Georgia
## 646 56449 646 California
## 647 56143 647 Kansas
## 648 56105 648 California
## 649 56069 649 Massachusetts
## 650 56002 650 Florida
## 651 55870 651 Ohio
## 652 55831 652 New Jersey
## 653 55816 653 Alabama
## 654 55717 654 Massachusetts
## 655 55670 655 Indiana
## 656 55456 656 Florida
## 657 55419 657 Massachusetts
## 658 55361 658 New York
## 659 55298 659 Oregon
## 660 55191 660 California
## 661 55174 661 California
## 662 55046 662 Connecticut
## 663 55000 663 California
## 664 54980 664 California
## 665 54932 665 North Dakota
## 666 54898 666 Texas
## 667 54842 667 Missouri
## 668 54790 668 Washington
## 669 54771 669 Illinois
## 670 54686 670 California
## 671 54664 671 Illinois
## 672 54561 672 California
## 673 54382 673 Utah
## 674 54350 674 Idaho
## 675 54291 675 California
## 676 54194 676 California
## 677 54135 677 Texas
## 678 54080 678 Nevada
## 679 54076 679 Texas
## 680 54068 680 Tennessee
## 681 53956 681 Ohio
## 682 53756 682 Massachusetts
## 683 53752 683 Texas
## 684 53665 684 Indiana
## 685 53663 685 Nebraska
## 686 53648 686 Illinois
## 687 53438 687 Georgia
## 688 53326 688 Florida
## 689 53294 689 Missouri
## 690 53243 690 California
## 691 53224 691 Texas
## 692 53063 692 Colorado
## 693 52977 693 California
## 694 52962 694 Tennessee
## 695 52844 695 Arizona
## 696 52703 696 Florida
## 697 52575 697 New Jersey
## 698 52536 698 California
## 699 52477 699 California
## 700 52413 700 Washington
## 701 52403 701 California
## 702 52398 702 Illinois
## 703 52363 703 Missouri
## 704 52206 704 California
## 705 52122 705 New Jersey
## 706 52105 706 California
## 707 52066 707 Illinois
## 708 52044 708 Massachusetts
## 709 51982 709 New Jersey
## 710 51848 710 Michigan
## 711 51763 711 Florida
## 712 51701 712 California
## 713 51644 713 Connecticut
## 714 51583 714 Oregon
## 715 51567 715 Iowa
## 716 51522 716 Wisconsin
## 717 51510 717 North Carolina
## 718 51483 718 Texas
## 719 51395 719 Virginia
## 720 51368 720 Minnesota
## 721 51265 721 Indiana
## 722 51143 722 Ohio
## 723 51074 723 California
## 724 50997 724 Mississippi
## 725 50821 725 West Virginia
## 726 50789 726 Missouri
## 727 50725 727 Oklahoma
## 728 50699 728 Florida
## 729 50603 729 Georgia
## 730 50588 730 New Jersey
## 731 50550 731 Nebraska
## 732 50508 732 California
## 733 50458 733 North Carolina
## 734 50444 734 Oregon
## 735 50344 735 Kansas
## 736 50303 736 Michigan
## 737 50233 737 Michigan
## 738 50213 738 Florida
## 739 50201 739 Minnesota
## 740 50195 740 Texas
## 741 50175 741 California
## 742 50169 742 Washington
## 743 50111 743 Arizona
## 744 49998 744 Florida
## 745 49974 745 New York
## 746 49891 746 California
## 747 49858 747 Washington
## 748 49799 748 Colorado
## 749 49761 749 Louisiana
## 750 49707 750 California
## 751 49670 751 Illinois
## 752 49631 752 Florida
## 753 49628 753 North Carolina
## 754 49468 754 New York
## 755 49417 755 California
## 756 49376 756 Minnesota
## 757 49267 757 Ohio
## 758 49228 758 California
## 759 49188 759 Pennsylvania
## 760 49177 760 West Virginia
## 761 49133 761 California
## 762 49087 762 California
## 763 48957 763 Idaho
## 764 48913 764 Utah
## 765 48733 765 Texas
## 766 48725 766 Wisconsin
## 767 48630 767 Ohio
## 768 48612 768 Utah
## 769 48611 769 New Mexico
## 770 48608 770 Colorado
## 771 48592 771 Texas
## 772 48554 772 Michigan
## 773 48514 773 Massachusetts
## 774 48508 774 California
## 775 48426 775 Louisiana
## 776 48338 776 Washington
## 777 48139 777 Ohio
## 778 47989 778 Indiana
## 779 47846 779 Kansas
## 780 47842 780 California
## 781 47777 781 Ohio
## 782 47749 782 Missouri
## 783 47673 783 Virginia
## 784 47591 784 Georgia
## 785 47556 785 Mississippi
## 786 47555 786 Michigan
## 787 47547 787 Florida
## 788 47523 788 Michigan
## 789 47411 789 Minnesota
## 790 47333 790 Tennessee
## 791 47333 791 Connecticut
## 792 47186 792 Oklahoma
## 793 47149 793 Rhode Island
## 794 47135 794 Indiana
## 795 47134 795 Wisconsin
## 796 46979 796 Ohio
## 797 46714 797 California
## 798 46663 798 Texas
## 799 46454 799 Ohio
## 800 46444 800 New York
## 801 46402 801 Idaho
## 802 46377 802 California
## 803 46321 803 North Dakota
## 804 46281 804 California
## 805 46094 805 Arkansas
## 806 46081 806 Texas
## 807 46074 807 South Carolina
## 808 45981 808 Idaho
## 809 45929 809 Indiana
## 810 45851 810 California
## 811 45799 811 Alabama
## 812 45796 812 Pennsylvania
## 813 45775 813 Indiana
## 814 45712 814 Ohio
## 815 45587 815 Florida
## 816 45556 816 Illinois
## 817 45508 817 Arizona
## 818 45426 818 New Mexico
## 819 45417 819 Illinois
## 820 45394 820 Ohio
## 821 45285 821 Utah
## 822 45237 822 California
## 823 45129 823 Arizona
## 824 44919 824 Washington
## 825 44820 825 Mississippi
## 826 44730 826 Ohio
## 827 44641 827 Massachusetts
## 828 44575 828 Texas
## 829 44412 829 New Jersey
## 830 44359 830 North Carolina
## 831 44349 831 Virginia
## 832 44275 832 Colorado
## 833 44206 833 Florida
## 834 44113 834 New Jersey
## 835 44096 835 California
## 836 44057 836 Massachusetts
## 837 43935 837 Pennsylvania
## 838 43907 838 Illinois
## 839 43886 839 Massachusetts
## 840 43849 840 Illinois
## 841 43609 841 Virginia
## 842 43607 842 Ohio
## 843 43580 843 Texas
## 844 43509 844 California
## 845 43363 845 California
## 846 43341 846 California
## 847 43330 847 Missouri
## 848 43328 848 Florida
## 849 43286 849 Florida
## 850 43250 850 Florida
## 851 43167 851 New York
## 852 43116 852 Illinois
## 853 43092 853 California
## 854 43074 854 Florida
## 855 43060 855 Tennessee
## 856 43023 856 Utah
## 857 42970 857 Wisconsin
## 858 42935 858 Massachusetts
## 859 42907 859 Virginia
## 860 42907 860 Texas
## 861 42895 861 Illinois
## 862 42889 862 California
## 863 42774 863 Tennessee
## 864 42757 864 Florida
## 865 42635 865 Ohio
## 866 42544 866 Massachusetts
## 867 42448 867 California
## 868 42443 868 California
## 869 42419 869 New Hampshire
## 870 42284 870 Vermont
## 871 42214 871 North Carolina
## 872 42181 872 Michigan
## 873 42150 873 Florida
## 874 41889 874 Kansas
## 875 41778 875 Illinois
## 876 41776 876 Iowa
## 877 41757 877 Pennsylvania
## 878 41752 878 Illinois
## 879 41734 879 Illinois
## 880 41705 880 Virginia
## 881 41679 881 Illinois
## 882 41664 882 New Jersey
## 883 41627 883 Arizona
## 884 41512 884 Ohio
## 885 41398 885 California
## 886 41301 887 Massachusetts
## 887 41301 886 New Jersey
## 888 41190 888 South Carolina
## 889 41108 889 Pennsylvania
## 890 41026 890 Rhode Island
## 891 41002 891 Massachusetts
## 892 40999 892 Connecticut
## 893 40963 893 California
## 894 40956 894 Kentucky
## 895 40922 895 Texas
## 896 40921 896 Mississippi
## 897 40921 897 Utah
## 898 40918 898 Florida
## 899 40915 899 Illinois
## 900 40836 900 California
## 901 40768 901 Ohio
## 902 40727 902 Washington
## 903 40714 903 Texas
## 904 40664 904 Massachusetts
## 905 40641 905 Minnesota
## 906 40612 906 Maryland
## 907 40590 907 Arizona
## 908 40584 908 California
## 909 40566 909 Iowa
## 910 40481 910 California
## 911 40435 911 California
## 912 40388 912 Illinois
## 913 40383 913 Massachusetts
## 914 40379 914 Illinois
## 915 40361 915 North Carolina
## 916 40351 916 Illinois
## 917 40347 917 Connecticut
## 918 40342 918 Texas
## 919 40275 919 California
## 920 40249 920 Massachusetts
## 921 40167 921 Arkansas
## 922 40059 922 Alabama
## 923 40059 923 Georgia
## 924 40021 924 Tennessee
## 925 39860 925 Montana
## 926 39834 926 Wisconsin
## 927 39823 927 South Carolina
## 928 39795 928 Texas
## 929 39791 929 Arizona
## 930 39765 930 Minnesota
## 931 39650 931 Illinois
## 932 39605 932 Texas
## 933 39551 933 New Jersey
## 934 39508 934 New Mexico
## 935 39458 935 Texas
## 936 39428 936 California
## 937 39414 937 Massachusetts
## 938 39412 938 South Carolina
## 939 39398 939 Minnesota
## 940 39389 940 California
## 941 39383 941 Arizona
## 942 39375 942 Tennessee
## 943 39331 943 California
## 944 39325 944 Ohio
## 945 39309 945 Wisconsin
## 946 39296 946 Texas
## 947 39172 947 Florida
## 948 39167 948 Minnesota
## 949 39083 949 Massachusetts
## 950 39056 950 Washington
## 951 38877 951 Illinois
## 952 38863 952 Oklahoma
## 953 38816 953 Missouri
## 954 38722 954 Maryland
## 955 38696 955 Florida
## 956 38661 956 Florida
## 957 38632 957 Florida
## 958 38623 958 California
## 959 38609 959 Washington
## 960 38606 960 California
## 961 38510 961 Illinois
## 962 38448 962 Texas
## 963 38355 963 Ohio
## 964 38290 964 Arizona
## 965 38241 965 Illinois
## 966 38194 966 California
## 967 38142 967 Ohio
## 968 38071 968 Texas
## 969 38027 969 California
## 970 38015 970 Illinois
## 971 37999 971 Wisconsin
## 972 37839 972 Illinois
## 973 37792 973 South Carolina
## 974 37733 974 Utah
## 975 37711 975 Florida
## 976 37670 976 Massachusetts
## 977 37659 977 New York
## 978 37647 978 South Carolina
## 979 37610 979 Oregon
## 980 37587 980 Texas
## 981 37530 981 Ohio
## 982 37499 982 Colorado
## 983 37498 983 Alabama
## 984 37490 984 Ohio
## 985 37442 985 Texas
## 986 37385 986 Illinois
## 987 37366 987 Delaware
## 988 37313 988 Michigan
## 989 37240 989 Illinois
## 990 37213 990 Michigan
## 991 37199 991 Florida
## 992 37165 992 California
## 993 37159 993 Wisconsin
## 994 37130 994 Arizona
## 995 37101 995 California
## 996 37093 996 Texas
## 997 37064 997 Oregon
## 998 36956 998 Utah
## 999 36888 999 Wisconsin
## 1000 36877 1000 Florida#This dataframe shows data on cities that experienced population growth from 2000 - 2013. The dataframe contains the city, state, lat and long as well as population and rank- Calculate the average population in the dataframe. Why is using mean() directly not working? Find a way to correct the data type of this variable so you can calculate the average (and then calculate the average)
Hint: use str(pop) or glimpse(pop) to help understand the dataframe
pop$population <-as.numeric(pop$population)
mean(pop$population)## [1] 131132.4 #The mean is 131132.4- What is the population of the smallest city in the dataframe? Which state is it in?
pop[which.min(pop$population),]## city growth_from_2000_to_2013 latitude longitude population rank
## 1000 Panama City 0.1% 30.15881 -85.66021 36877 1000
## state
## 1000 Florida#Population is 36877 and is for Panama CityStep 2: Merge the population data with the state name data
- Read in the state name .csv file from the URL below into a dataframe named abbr (for “abbreviation”) – make sure to use the read_csv() function from the tidyverse package:
https://intro-datascience.s3.us-east-2.amazonaws.com/statesInfo.csv
abbr<- read_csv(url("https://intro-datascience.s3.us-east-2.amazonaws.com/statesInfo.csv"))## Rows: 51 Columns: 2## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (2): State, Abbreviation##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.abbr## # A tibble: 51 × 2
## State Abbreviation
## <chr> <chr>
## 1 Alabama AL
## 2 Alaska AK
## 3 Arizona AZ
## 4 Arkansas AR
## 5 California CA
## 6 Colorado CO
## 7 Connecticut CT
## 8 Delaware DE
## 9 District of Columbia DC
## 10 Florida FL
## # … with 41 more rows- To successfully merge the dataframe pop with the abbr dataframe, we need to identify a column they have in common which will serve as the “key” to merge on. One column both dataframes have is the state column. The only problem is the slight column name discrepancy – in pop, the column is called “state” and in abbr – “State.” These names need to be reconciled for the merge() function to work. Find a way to rename abbr’s “State” to match the state column in pop.
abbr <- abbr %>%
rename(state=State)
abbr## # A tibble: 51 × 2
## state Abbreviation
## <chr> <chr>
## 1 Alabama AL
## 2 Alaska AK
## 3 Arizona AZ
## 4 Arkansas AR
## 5 California CA
## 6 Colorado CO
## 7 Connecticut CT
## 8 Delaware DE
## 9 District of Columbia DC
## 10 Florida FL
## # … with 41 more rows- Merge the two dataframes (using the ‘state’ column from both dataframes), storing the resulting dataframe in dfNew.
dfNew <- merge(abbr, pop, by= 'state')
dfNew ## state Abbreviation city
## 1 Alabama AL Mobile
## 2 Alabama AL Phenix City
## 3 Alabama AL Montgomery
## 4 Alabama AL Decatur
## 5 Alabama AL Huntsville
## 6 Alabama AL Madison
## 7 Alabama AL Tuscaloosa
## 8 Alabama AL Florence
## 9 Alabama AL Auburn
## 10 Alabama AL Hoover
## 11 Alabama AL Dothan
## 12 Alabama AL Birmingham
## 13 Alaska AK Anchorage
## 14 Arizona AZ Casa Grande
## 15 Arizona AZ Gilbert
## 16 Arizona AZ Surprise
## 17 Arizona AZ Scottsdale
## 18 Arizona AZ Bullhead City
## 19 Arizona AZ Glendale
## 20 Arizona AZ Prescott
## 21 Arizona AZ Mesa
## 22 Arizona AZ Tempe
## 23 Arizona AZ Flagstaff
## 24 Arizona AZ Marana
## 25 Arizona AZ Tucson
## 26 Arizona AZ Apache Junction
## 27 Arizona AZ Prescott Valley
## 28 Arizona AZ Peoria
## 29 Arizona AZ Avondale
## 30 Arizona AZ Maricopa
## 31 Arizona AZ Yuma
## 32 Arizona AZ Phoenix
## 33 Arizona AZ Goodyear
## 34 Arizona AZ Chandler
## 35 Arizona AZ Buckeye
## 36 Arizona AZ Oro Valley
## 37 Arizona AZ Sierra Vista
## 38 Arizona AZ Lake Havasu City
## 39 Arkansas AR Bentonville
## 40 Arkansas AR Pine Bluff
## 41 Arkansas AR Springdale
## 42 Arkansas AR Rogers
## 43 Arkansas AR Conway
## 44 Arkansas AR Fort Smith
## 45 Arkansas AR North Little Rock
## 46 Arkansas AR Jonesboro
## 47 Arkansas AR Fayetteville
## 48 Arkansas AR Little Rock
## 49 California CA Elk Grove
## 50 California CA Santee
## 51 California CA Napa
## 52 California CA Temecula
## 53 California CA Carson
## 54 California CA San Rafael
## 55 California CA Pomona
## 56 California CA Walnut Creek
## 57 California CA San Mateo
## 58 California CA Lancaster
## 59 California CA Santa Rosa
## 60 California CA Oceanside
## 61 California CA Murrieta
## 62 California CA Alhambra
## 63 California CA Ontario
## 64 California CA Livermore
## 65 California CA Santa Clarita
## 66 California CA San Clemente
## 67 California CA San Francisco
## 68 California CA Los Angeles
## 69 California CA Fontana
## 70 California CA South Gate
## 71 California CA Jurupa Valley
## 72 California CA Alameda
## 73 California CA Rancho Cucamonga
## 74 California CA Fresno
## 75 California CA Sacramento
## 76 California CA San Luis Obispo
## 77 California CA Norwalk
## 78 California CA Montebello
## 79 California CA Santa Maria
## 80 California CA Yorba Linda
## 81 California CA Oxnard
## 82 California CA Rialto
## 83 California CA Carlsbad
## 84 California CA Santa Monica
## 85 California CA Oakland
## 86 California CA San Ramon
## 87 California CA Citrus Heights
## 88 California CA San Diego
## 89 California CA Sunnyvale
## 90 California CA Stockton
## 91 California CA San Jose
## 92 California CA Bakersfield
## 93 California CA Monterey Park
## 94 California CA Glendale
## 95 California CA Laguna Niguel
## 96 California CA Anaheim
## 97 California CA Santa Ana
## 98 California CA Tustin
## 99 California CA Riverside
## 100 California CA San Bernardino
## 101 California CA Orange
## 102 California CA Vallejo
## 103 California CA Perris
## 104 California CA San Marcos
## 105 California CA Modesto
## 106 California CA Lodi
## 107 California CA Clovis
## 108 California CA Monrovia
## 109 California CA Chico
## 110 California CA Berkeley
## 111 California CA Daly City
## 112 California CA Moreno Valley
## 113 California CA Burbank
## 114 California CA Newport Beach
## 115 California CA Vacaville
## 116 California CA Palmdale
## 117 California CA Merced
## 118 California CA Palm Springs
## 119 California CA Turlock
## 120 California CA Mission Viejo
## 121 California CA Hayward
## 122 California CA Hawthorne
## 123 California CA Montclair
## 124 California CA Redlands
## 125 California CA San Jacinto
## 126 California CA Milpitas
## 127 California CA Yuba City
## 128 California CA Huntington Park
## 129 California CA Simi Valley
## 130 California CA Westminster
## 131 California CA Torrance
## 132 California CA Cerritos
## 133 California CA Redding
## 134 California CA Fairfield
## 135 California CA Garden Grove
## 136 California CA Delano
## 137 California CA San Buenaventura (Ventura)
## 138 California CA Fremont
## 139 California CA Brentwood
## 140 California CA West Covina
## 141 California CA Richmond
## 142 California CA Menifee
## 143 California CA Pasadena
## 144 California CA Antioch
## 145 California CA Davis
## 146 California CA Hanford
## 147 California CA La Puente
## 148 California CA Rosemead
## 149 California CA Diamond Bar
## 150 California CA Poway
## 151 California CA Baldwin Park
## 152 California CA Chino Hills
## 153 California CA Santa Cruz
## 154 California CA Corona
## 155 California CA Apple Valley
## 156 California CA Chula Vista
## 157 California CA Thousand Oaks
## 158 California CA Concord
## 159 California CA South San Francisco
## 160 California CA Danville
## 161 California CA Visalia
## 162 California CA Azusa
## 163 California CA Redwood City
## 164 California CA Porterville
## 165 California CA La Quinta
## 166 California CA Escondido
## 167 California CA Encinitas
## 168 California CA Pleasanton
## 169 California CA Tracy
## 170 California CA La Mesa
## 171 California CA Fullerton
## 172 California CA Vista
## 173 California CA Cupertino
## 174 California CA Morgan Hill
## 175 California CA Gilroy
## 176 California CA Aliso Viejo
## 177 California CA Gardena
## 178 California CA San Leandro
## 179 California CA Victorville
## 180 California CA Compton
## 181 California CA Indio
## 182 California CA Mountain View
## 183 California CA Union City
## 184 California CA Fountain Valley
## 185 California CA Huntington Beach
## 186 California CA Costa Mesa
## 187 California CA Chino
## 188 California CA Camarillo
## 189 California CA Inglewood
## 190 California CA Eastvale
## 191 California CA Lincoln
## 192 California CA National City
## 193 California CA Novato
## 194 California CA El Monte
## 195 California CA Palo Alto
## 196 California CA Pacifica
## 197 California CA Covina
## 198 California CA Culver City
## 199 California CA Manteca
## 200 California CA Martinez
## 201 California CA Yucaipa
## 202 California CA Watsonville
## 203 California CA El Cajon
## 204 California CA Lynwood
## 205 California CA Newark
## 206 California CA Irvine
## 207 California CA Lake Forest
## 208 California CA Palm Desert
## 209 California CA Cathedral City
## 210 California CA Arcadia
## 211 California CA San Bruno
## 212 California CA Long Beach
## 213 California CA Downey
## 214 California CA El Centro
## 215 California CA Upland
## 216 California CA Calexico
## 217 California CA Lompoc
## 218 California CA Bell Gardens
## 219 California CA Madera
## 220 California CA Santa Clara
## 221 California CA Paramount
## 222 California CA Dublin
## 223 California CA Rancho Santa Margarita
## 224 California CA Colton
## 225 California CA Rancho Palos Verdes
## 226 California CA Buena Park
## 227 California CA Bellflower
## 228 California CA Tulare
## 229 California CA Oakley
## 230 California CA Rohnert Park
## 231 California CA Glendora
## 232 California CA Folsom
## 233 California CA Stanton
## 234 California CA Hemet
## 235 California CA Rocklin
## 236 California CA Coachella
## 237 California CA Campbell
## 238 California CA West Sacramento
## 239 California CA La Mirada
## 240 California CA Salinas
## 241 California CA Woodland
## 242 California CA Whittier
## 243 California CA Petaluma
## 244 California CA Lakewood
## 245 California CA Cypress
## 246 California CA La Habra
## 247 California CA Roseville
## 248 California CA Brea
## 249 California CA Redondo Beach
## 250 California CA Lake Elsinore
## 251 California CA Beaumont
## 252 California CA Santa Barbara
## 253 California CA Pico Rivera
## 254 California CA Pittsburg
## 255 California CA Rancho Cordova
## 256 California CA Ceres
## 257 California CA Placentia
## 258 California CA San Gabriel
## 259 California CA Hesperia
## 260 California CA Highland
## 261 Colorado CO Centennial
## 262 Colorado CO Thornton
## 263 Colorado CO Lakewood
## 264 Colorado CO Parker
## 265 Colorado CO Pueblo
## 266 Colorado CO Greeley
## 267 Colorado CO Loveland
## 268 Colorado CO Castle Rock
## 269 Colorado CO Commerce City
## 270 Colorado CO Fort Collins
## 271 Colorado CO Littleton
## 272 Colorado CO Westminster
## 273 Colorado CO Colorado Springs
## 274 Colorado CO Denver
## 275 Colorado CO Longmont
## 276 Colorado CO Aurora
## 277 Colorado CO Arvada
## 278 Colorado CO Northglenn
## 279 Colorado CO Grand Junction
## 280 Colorado CO Broomfield
## 281 Colorado CO Boulder
## 282 Connecticut CT Bridgeport
## 283 Connecticut CT Danbury
## 284 Connecticut CT New Britain
## 285 Connecticut CT Middletown
## 286 Connecticut CT Stamford
## 287 Connecticut CT New Haven
## 288 Connecticut CT Milford
## 289 Connecticut CT Hartford
## 290 Connecticut CT West Haven
## 291 Connecticut CT Norwalk
## 292 Connecticut CT Bristol
## 293 Connecticut CT Meriden
## 294 Connecticut CT Shelton
## 295 Connecticut CT Waterbury
## 296 Connecticut CT Norwich
## 297 Delaware DE Wilmington
## 298 Delaware DE Dover
## 299 District of Columbia DC Washington
## 300 Florida FL Lauderhill
## 301 Florida FL Tallahassee
## 302 Florida FL Miami Gardens
## 303 Florida FL North Miami Beach
## 304 Florida FL Doral
## 305 Florida FL Lakeland
## 306 Florida FL Tamarac
## 307 Florida FL Fort Lauderdale
## 308 Florida FL Clearwater
## 309 Florida FL Sarasota
## 310 Florida FL Altamonte Springs
## 311 Florida FL Palm Bay
## 312 Florida FL Gainesville
## 313 Florida FL Titusville
## 314 Florida FL Delray Beach
## 315 Florida FL Palm Beach Gardens
## 316 Florida FL Coconut Creek
## 317 Florida FL Pinellas Park
## 318 Florida FL St. Cloud
## 319 Florida FL Port Orange
## 320 Florida FL Bradenton
## 321 Florida FL Winter Garden
## 322 Florida FL Deltona
## 323 Florida FL Weston
## 324 Florida FL Largo
## 325 Florida FL Coral Gables
## 326 Florida FL Miami
## 327 Florida FL Homestead
## 328 Florida FL Miramar
## 329 Florida FL North Port
## 330 Florida FL Fort Pierce
## 331 Florida FL Kissimmee
## 332 Florida FL Pensacola
## 333 Florida FL Palm Coast
## 334 Florida FL Jacksonville
## 335 Florida FL Miami Beach
## 336 Florida FL West Palm Beach
## 337 Florida FL Pembroke Pines
## 338 Florida FL Jupiter
## 339 Florida FL Plantation
## 340 Florida FL Ormond Beach
## 341 Florida FL Pompano Beach
## 342 Florida FL Margate
## 343 Florida FL Ocoee
## 344 Florida FL Orlando
## 345 Florida FL Hialeah
## 346 Florida FL Apopka
## 347 Florida FL Davie
## 348 Florida FL Melbourne
## 349 Florida FL Oakland Park
## 350 Florida FL Hollywood
## 351 Florida FL Panama City
## 352 Florida FL Hallandale Beach
## 353 Florida FL Coral Springs
## 354 Florida FL Sunrise
## 355 Florida FL St. Petersburg
## 356 Florida FL Boynton Beach
## 357 Florida FL Tampa
## 358 Florida FL Daytona Beach
## 359 Florida FL Fort Myers
## 360 Florida FL Cape Coral
## 361 Florida FL Bonita Springs
## 362 Florida FL North Miami
## 363 Florida FL Boca Raton
## 364 Florida FL North Lauderdale
## 365 Florida FL Sanford
## 366 Florida FL Greenacres
## 367 Florida FL Port St. Lucie
## 368 Florida FL Aventura
## 369 Florida FL Deerfield Beach
## 370 Florida FL Cutler Bay
## 371 Florida FL Ocala
## 372 Florida FL Wellington
## 373 Georgia GA Atlanta
## 374 Georgia GA Marietta
## 375 Georgia GA Roswell
## 376 Georgia GA Smyrna
## 377 Georgia GA Peachtree Corners
## 378 Georgia GA Sandy Springs
## 379 Georgia GA Johns Creek
## 380 Georgia GA Athens-Clarke County
## 381 Georgia GA Columbus
## 382 Georgia GA Dunwoody
## 383 Georgia GA Augusta-Richmond County
## 384 Georgia GA Valdosta
## 385 Georgia GA Albany
## 386 Georgia GA Warner Robins
## 387 Georgia GA Macon
## 388 Georgia GA Brookhaven
## 389 Georgia GA Savannah
## 390 Georgia GA Alpharetta
## 391 Hawaii HI Honolulu
## 392 Idaho ID Idaho Falls
## 393 Idaho ID Twin Falls
## 394 Idaho ID Pocatello
## 395 Idaho ID Caldwell
## 396 Idaho ID Meridian
## 397 Idaho ID Coeur d'Alene
## 398 Idaho ID Nampa
## 399 Idaho ID Boise City
## 400 Illinois IL Carol Stream
## 401 Illinois IL Elgin
## 402 Illinois IL Rockford
## 403 Illinois IL Cicero
## 404 Illinois IL Streamwood
## 405 Illinois IL Quincy
## 406 Illinois IL Park Ridge
## 407 Illinois IL Skokie
## 408 Illinois IL Bartlett
## 409 Illinois IL Moline
## 410 Illinois IL DeKalb
## 411 Illinois IL Oak Lawn
## 412 Illinois IL Bolingbrook
## 413 Illinois IL Joliet
## 414 Illinois IL Normal
## 415 Illinois IL Waukegan
## 416 Illinois IL Carpentersville
## 417 Illinois IL Crystal Lake
## 418 Illinois IL Buffalo Grove
## 419 Illinois IL Naperville
## 420 Illinois IL Lombard
## 421 Illinois IL Peoria
## 422 Illinois IL Arlington Heights
## 423 Illinois IL Orland Park
## 424 Illinois IL Elmhurst
## 425 Illinois IL Hanover Park
## 426 Illinois IL Champaign
## 427 Illinois IL Tinley Park
## 428 Illinois IL Downers Grove
## 429 Illinois IL Mount Prospect
## 430 Illinois IL Glenview
## 431 Illinois IL Aurora
## 432 Illinois IL Schaumburg
## 433 Illinois IL Romeoville
## 434 Illinois IL Chicago
## 435 Illinois IL Plainfield
## 436 Illinois IL Berwyn
## 437 Illinois IL Des Plaines
## 438 Illinois IL Decatur
## 439 Illinois IL Urbana
## 440 Illinois IL Oak Park
## 441 Illinois IL Rock Island
## 442 Illinois IL Wheaton
## 443 Illinois IL Palatine
## 444 Illinois IL Springfield
## 445 Illinois IL Addison
## 446 Illinois IL Belleville
## 447 Illinois IL Calumet City
## 448 Illinois IL Wheeling
## 449 Illinois IL Bloomington
## 450 Illinois IL Evanston
## 451 Illinois IL Hoffman Estates
## 452 Indiana IN Gary
## 453 Indiana IN Terre Haute
## 454 Indiana IN Indianapolis
## 455 Indiana IN Bloomington
## 456 Indiana IN Lafayette
## 457 Indiana IN Noblesville
## 458 Indiana IN Mishawaka
## 459 Indiana IN Muncie
## 460 Indiana IN Carmel
## 461 Indiana IN Columbus
## 462 Indiana IN Kokomo
## 463 Indiana IN Hammond
## 464 Indiana IN Anderson
## 465 Indiana IN Greenwood
## 466 Indiana IN Lawrence
## 467 Indiana IN Elkhart
## 468 Indiana IN Evansville
## 469 Indiana IN Jeffersonville
## 470 Indiana IN Fishers
## 471 Indiana IN South Bend
## 472 Indiana IN Fort Wayne
## 473 Iowa IA Iowa City
## 474 Iowa IA Cedar Rapids
## 475 Iowa IA Davenport
## 476 Iowa IA Sioux City
## 477 Iowa IA Ames
## 478 Iowa IA Dubuque
## 479 Iowa IA Ankeny
## 480 Iowa IA West Des Moines
## 481 Iowa IA Council Bluffs
## 482 Iowa IA Des Moines
## 483 Iowa IA Urbandale
## 484 Iowa IA Cedar Falls
## 485 Iowa IA Waterloo
## 486 Kansas KS Overland Park
## 487 Kansas KS Wichita
## 488 Kansas KS Salina
## 489 Kansas KS Lenexa
## 490 Kansas KS Topeka
## 491 Kansas KS Kansas City
## 492 Kansas KS Hutchinson
## 493 Kansas KS Olathe
## 494 Kansas KS Lawrence
## 495 Kansas KS Manhattan
## 496 Kansas KS Shawnee
## 497 Kentucky KY Owensboro
## 498 Kentucky KY Lexington-Fayette
## 499 Kentucky KY Bowling Green
## 500 Kentucky KY Louisville/Jefferson County
## 501 Kentucky KY Covington
## 502 Louisiana LA Bossier City
## 503 Louisiana LA Alexandria
## 504 Louisiana LA Kenner
## 505 Louisiana LA Shreveport
## 506 Louisiana LA New Orleans
## 507 Louisiana LA Lake Charles
## 508 Louisiana LA Monroe
## 509 Louisiana LA Baton Rouge
## 510 Louisiana LA Lafayette
## 511 Maine ME Portland
## 512 Maryland MD Rockville
## 513 Maryland MD Bowie
## 514 Maryland MD Frederick
## 515 Maryland MD Baltimore
## 516 Maryland MD Gaithersburg
## 517 Maryland MD Hagerstown
## 518 Maryland MD Annapolis
## 519 Massachusetts MA Westfield
## 520 Massachusetts MA Medford
## 521 Massachusetts MA Everett
## 522 Massachusetts MA Lawrence
## 523 Massachusetts MA New Bedford
## 524 Massachusetts MA Newton
## 525 Massachusetts MA Barnstable Town
## 526 Massachusetts MA Peabody
## 527 Massachusetts MA Lynn
## 528 Massachusetts MA Quincy
## 529 Massachusetts MA Leominster
## 530 Massachusetts MA Weymouth Town
## 531 Massachusetts MA Fitchburg
## 532 Massachusetts MA Lowell
## 533 Massachusetts MA Marlborough
## 534 Massachusetts MA Holyoke
## 535 Massachusetts MA Attleboro
## 536 Massachusetts MA Chicopee
## 537 Massachusetts MA Taunton
## 538 Massachusetts MA Brockton
## 539 Massachusetts MA Haverhill
## 540 Massachusetts MA Waltham
## 541 Massachusetts MA Cambridge
## 542 Massachusetts MA Woburn
## 543 Massachusetts MA Pittsfield
## 544 Massachusetts MA Beverly
## 545 Massachusetts MA Boston
## 546 Massachusetts MA Worcester
## 547 Massachusetts MA Methuen
## 548 Massachusetts MA Somerville
## 549 Massachusetts MA Revere
## 550 Massachusetts MA Fall River
## 551 Massachusetts MA Malden
## 552 Massachusetts MA Chelsea
## 553 Massachusetts MA Springfield
## 554 Massachusetts MA Salem
## 555 Michigan MI Livonia
## 556 Michigan MI Battle Creek
## 557 Michigan MI Dearborn Heights
## 558 Michigan MI Roseville
## 559 Michigan MI Royal Oak
## 560 Michigan MI Southfield
## 561 Michigan MI Westland
## 562 Michigan MI Kentwood
## 563 Michigan MI Midland
## 564 Michigan MI East Lansing
## 565 Michigan MI Portage
## 566 Michigan MI Dearborn
## 567 Michigan MI Rochester Hills
## 568 Michigan MI Pontiac
## 569 Michigan MI Taylor
## 570 Michigan MI Flint
## 571 Michigan MI Lansing
## 572 Michigan MI Grand Rapids
## 573 Michigan MI Muskegon
## 574 Michigan MI Farmington Hills
## 575 Michigan MI Lincoln Park
## 576 Michigan MI St. Clair Shores
## 577 Michigan MI Troy
## 578 Michigan MI Warren
## 579 Michigan MI Saginaw
## 580 Michigan MI Novi
## 581 Michigan MI Ann Arbor
## 582 Michigan MI Sterling Heights
## 583 Michigan MI Detroit
## 584 Michigan MI Wyoming
## 585 Michigan MI Kalamazoo
## 586 Minnesota MN Bloomington
## 587 Minnesota MN Apple Valley
## 588 Minnesota MN Brooklyn Park
## 589 Minnesota MN Moorhead
## 590 Minnesota MN Rochester
## 591 Minnesota MN Woodbury
## 592 Minnesota MN Coon Rapids
## 593 Minnesota MN Plymouth
## 594 Minnesota MN Eagan
## 595 Minnesota MN Lakeville
## 596 Minnesota MN St. Paul
## 597 Minnesota MN St. Louis Park
## 598 Minnesota MN Maple Grove
## 599 Minnesota MN Duluth
## 600 Minnesota MN Maplewood
## 601 Minnesota MN Shakopee
## 602 Minnesota MN Mankato
## 603 Minnesota MN St. Cloud
## 604 Minnesota MN Blaine
## 605 Minnesota MN Edina
## 606 Minnesota MN Minneapolis
## 607 Minnesota MN Minnetonka
## 608 Minnesota MN Eden Prairie
## 609 Minnesota MN Burnsville
## 610 Mississippi MS Southaven
## 611 Mississippi MS Jackson
## 612 Mississippi MS Meridian
## 613 Mississippi MS Hattiesburg
## 614 Mississippi MS Gulfport
## 615 Mississippi MS Biloxi
## 616 Missouri MO Jefferson City
## 617 Missouri MO Springfield
## 618 Missouri MO Independence
## 619 Missouri MO Lee's Summit
## 620 Missouri MO Joplin
## 621 Missouri MO Chesterfield
## 622 Missouri MO Blue Springs
## 623 Missouri MO St. Charles
## 624 Missouri MO Cape Girardeau
## 625 Missouri MO St. Louis
## 626 Missouri MO Kansas City
## 627 Missouri MO Florissant
## 628 Missouri MO Columbia
## 629 Missouri MO St. Joseph
## 630 Missouri MO O'Fallon
## 631 Missouri MO St. Peters
## 632 Montana MT Billings
## 633 Montana MT Great Falls
## 634 Montana MT Missoula
## 635 Montana MT Bozeman
## 636 Nebraska NE Bellevue
## 637 Nebraska NE Grand Island
## 638 Nebraska NE Lincoln
## 639 Nebraska NE Omaha
## 640 Nevada NV Reno
## 641 Nevada NV Las Vegas
## 642 Nevada NV Carson City
## 643 Nevada NV Henderson
## 644 Nevada NV North Las Vegas
## 645 Nevada NV Sparks
## 646 New Hampshire NH Concord
## 647 New Hampshire NH Manchester
## 648 New Hampshire NH Nashua
## 649 New Jersey NJ Trenton
## 650 New Jersey NJ West New York
## 651 New Jersey NJ Clifton
## 652 New Jersey NJ Sayreville
## 653 New Jersey NJ Hoboken
## 654 New Jersey NJ Elizabeth
## 655 New Jersey NJ Vineland
## 656 New Jersey NJ Perth Amboy
## 657 New Jersey NJ Passaic
## 658 New Jersey NJ Kearny
## 659 New Jersey NJ Camden
## 660 New Jersey NJ Newark
## 661 New Jersey NJ Jersey City
## 662 New Jersey NJ Plainfield
## 663 New Jersey NJ Bayonne
## 664 New Jersey NJ Linden
## 665 New Jersey NJ Atlantic City
## 666 New Jersey NJ Hackensack
## 667 New Jersey NJ East Orange
## 668 New Jersey NJ New Brunswick
## 669 New Jersey NJ Union City
## 670 New Jersey NJ Paterson
## 671 New Mexico NM Las Cruces
## 672 New Mexico NM Farmington
## 673 New Mexico NM Santa Fe
## 674 New Mexico NM Clovis
## 675 New Mexico NM Albuquerque
## 676 New Mexico NM Roswell
## 677 New Mexico NM Rio Rancho
## 678 New York NY Freeport
## 679 New York NY Rochester
## 680 New York NY Troy
## 681 New York NY Buffalo
## 682 New York NY Albany
## 683 New York NY Schenectady
## 684 New York NY Yonkers
## 685 New York NY White Plains
## 686 New York NY Niagara Falls
## 687 New York NY Binghamton
## 688 New York NY Valley Stream
## 689 New York NY Utica
## 690 New York NY Syracuse
## 691 New York NY New Rochelle
## 692 New York NY Mount Vernon
## 693 New York NY New York
## 694 New York NY Hempstead
## 695 North Carolina NC Wilmington
## 696 North Carolina NC Wilson
## 697 North Carolina NC Hickory
## 698 North Carolina NC Greensboro
## 699 North Carolina NC Apex
## 700 North Carolina NC Jacksonville
## 701 North Carolina NC High Point
## 702 North Carolina NC Huntersville
## 703 North Carolina NC Greenville
## 704 North Carolina NC Fayetteville
## 705 North Carolina NC Chapel Hill
## 706 North Carolina NC Cary
## 707 North Carolina NC Asheville
## 708 North Carolina NC Winston-Salem
## 709 North Carolina NC Charlotte
## 710 North Carolina NC Burlington
## 711 North Carolina NC Concord
## 712 North Carolina NC Durham
## 713 North Carolina NC Kannapolis
## 714 North Carolina NC Raleigh
## 715 North Carolina NC Rocky Mount
## 716 North Carolina NC Gastonia
## 717 North Dakota ND Bismarck
## 718 North Dakota ND Fargo
## 719 North Dakota ND Minot
## 720 North Dakota ND Grand Forks
## 721 Ohio OH Euclid
## 722 Ohio OH Cincinnati
## 723 Ohio OH Huber Heights
## 724 Ohio OH Lorain
## 725 Ohio OH Beavercreek
## 726 Ohio OH Canton
## 727 Ohio OH Elyria
## 728 Ohio OH Cleveland
## 729 Ohio OH Findlay
## 730 Ohio OH Grove City
## 731 Ohio OH Westerville
## 732 Ohio OH Toledo
## 733 Ohio OH Kettering
## 734 Ohio OH Akron
## 735 Ohio OH Fairfield
## 736 Ohio OH Strongsville
## 737 Ohio OH Hamilton
## 738 Ohio OH Springfield
## 739 Ohio OH Lakewood
## 740 Ohio OH Lima
## 741 Ohio OH Lancaster
## 742 Ohio OH Mansfield
## 743 Ohio OH Youngstown
## 744 Ohio OH Columbus
## 745 Ohio OH Dublin
## 746 Ohio OH Mentor
## 747 Ohio OH Cuyahoga Falls
## 748 Ohio OH Warren
## 749 Ohio OH Cleveland Heights
## 750 Ohio OH Dayton
## 751 Ohio OH Parma
## 752 Ohio OH Newark
## 753 Ohio OH Middletown
## 754 Oklahoma OK Muskogee
## 755 Oklahoma OK Tulsa
## 756 Oklahoma OK Oklahoma City
## 757 Oklahoma OK Midwest City
## 758 Oklahoma OK Edmond
## 759 Oklahoma OK Norman
## 760 Oklahoma OK Broken Arrow
## 761 Oklahoma OK Enid
## 762 Oklahoma OK Stillwater
## 763 Oklahoma OK Lawton
## 764 Oklahoma OK Moore
## 765 Oregon OR Tigard
## 766 Oregon OR Corvallis
## 767 Oregon OR Keizer
## 768 Oregon OR Gresham
## 769 Oregon OR Hillsboro
## 770 Oregon OR Albany
## 771 Oregon OR Beaverton
## 772 Oregon OR Portland
## 773 Oregon OR Springfield
## 774 Oregon OR Eugene
## 775 Oregon OR Medford
## 776 Oregon OR Bend
## 777 Oregon OR Salem
## 778 Oregon OR Lake Oswego
## 779 Pennsylvania PA Wilkes-Barre
## 780 Pennsylvania PA State College
## 781 Pennsylvania PA Philadelphia
## 782 Pennsylvania PA Lancaster
## 783 Pennsylvania PA York
## 784 Pennsylvania PA Scranton
## 785 Pennsylvania PA Harrisburg
## 786 Pennsylvania PA Altoona
## 787 Pennsylvania PA Bethlehem
## 788 Pennsylvania PA Reading
## 789 Pennsylvania PA Erie
## 790 Pennsylvania PA Pittsburgh
## 791 Pennsylvania PA Allentown
## 792 Rhode Island RI Cranston
## 793 Rhode Island RI Warwick
## 794 Rhode Island RI East Providence
## 795 Rhode Island RI Providence
## 796 Rhode Island RI Woonsocket
## 797 Rhode Island RI Pawtucket
## 798 South Carolina SC Greenville
## 799 South Carolina SC Columbia
## 800 South Carolina SC Charleston
## 801 South Carolina SC Sumter
## 802 South Carolina SC Summerville
## 803 South Carolina SC Spartanburg
## 804 South Carolina SC Mount Pleasant
## 805 South Carolina SC Hilton Head Island
## 806 South Carolina SC Rock Hill
## 807 South Carolina SC Goose Creek
## 808 South Carolina SC North Charleston
## 809 South Carolina SC Florence
## 810 South Dakota SD Sioux Falls
## 811 South Dakota SD Rapid City
## 812 Tennessee TN Murfreesboro
## 813 Tennessee TN Kingsport
## 814 Tennessee TN Nashville-Davidson
## 815 Tennessee TN Knoxville
## 816 Tennessee TN Germantown
## 817 Tennessee TN Bartlett
## 818 Tennessee TN Johnson City
## 819 Tennessee TN Collierville
## 820 Tennessee TN Jackson
## 821 Tennessee TN Memphis
## 822 Tennessee TN Smyrna
## 823 Tennessee TN Clarksville
## 824 Tennessee TN Hendersonville
## 825 Tennessee TN Cleveland
## 826 Tennessee TN Brentwood
## 827 Tennessee TN Franklin
## 828 Tennessee TN Chattanooga
## 829 Texas TX Richardson
## 830 Texas TX Carrollton
## 831 Texas TX Port Arthur
## 832 Texas TX Huntsville
## 833 Texas TX Corpus Christi
## 834 Texas TX New Braunfels
## 835 Texas TX Austin
## 836 Texas TX Lewisville
## 837 Texas TX League City
## 838 Texas TX Coppell
## 839 Texas TX Sherman
## 840 Texas TX Pearland
## 841 Texas TX Fort Worth
## 842 Texas TX Flower Mound
## 843 Texas TX Friendswood
## 844 Texas TX North Richland Hills
## 845 Texas TX Arlington
## 846 Texas TX Texas City
## 847 Texas TX Temple
## 848 Texas TX Conroe
## 849 Texas TX Galveston
## 850 Texas TX Wichita Falls
## 851 Texas TX Houston
## 852 Texas TX Allen
## 853 Texas TX Lubbock
## 854 Texas TX Georgetown
## 855 Texas TX Brownsville
## 856 Texas TX Cedar Park
## 857 Texas TX Grand Prairie
## 858 Texas TX Pharr
## 859 Texas TX Frisco
## 860 Texas TX Irving
## 861 Texas TX Laredo
## 862 Texas TX Mesquite
## 863 Texas TX Harlingen
## 864 Texas TX Mansfield
## 865 Texas TX Texarkana
## 866 Texas TX San Angelo
## 867 Texas TX Hurst
## 868 Texas TX Round Rock
## 869 Texas TX Tyler
## 870 Texas TX Victoria
## 871 Texas TX Beaumont
## 872 Texas TX Pflugerville
## 873 Texas TX McAllen
## 874 Texas TX Bryan
## 875 Texas TX Burleson
## 876 Texas TX Sugar Land
## 877 Texas TX Denton
## 878 Texas TX Weslaco
## 879 Texas TX Longview
## 880 Texas TX McKinney
## 881 Texas TX Dallas
## 882 Texas TX Rockwall
## 883 Texas TX Pasadena
## 884 Texas TX Mission
## 885 Texas TX College Station
## 886 Texas TX Amarillo
## 887 Texas TX Wylie
## 888 Texas TX Edinburg
## 889 Texas TX Missouri City
## 890 Texas TX Plano
## 891 Texas TX San Marcos
## 892 Texas TX Bedford
## 893 Texas TX Abilene
## 894 Texas TX El Paso
## 895 Texas TX Baytown
## 896 Texas TX The Colony
## 897 Texas TX Haltom City
## 898 Texas TX Killeen
## 899 Texas TX Lancaster
## 900 Texas TX Garland
## 901 Texas TX Midland
## 902 Texas TX Grapevine
## 903 Texas TX Duncanville
## 904 Texas TX Euless
## 905 Texas TX DeSoto
## 906 Texas TX Cedar Hill
## 907 Texas TX Waco
## 908 Texas TX Rowlett
## 909 Texas TX San Antonio
## 910 Texas TX Keller
## 911 Texas TX Odessa
## 912 Utah UT Lehi
## 913 Utah UT Spanish Fork
## 914 Utah UT Sandy
## 915 Utah UT St. George
## 916 Utah UT South Jordan
## 917 Utah UT Orem
## 918 Utah UT West Valley City
## 919 Utah UT Provo
## 920 Utah UT Logan
## 921 Utah UT Layton
## 922 Utah UT Riverton
## 923 Utah UT Bountiful
## 924 Utah UT Salt Lake City
## 925 Utah UT Murray
## 926 Utah UT Draper
## 927 Utah UT Roy
## 928 Utah UT Ogden
## 929 Utah UT West Jordan
## 930 Utah UT Taylorsville
## 931 Vermont VT Burlington
## 932 Virginia VA Alexandria
## 933 Virginia VA Blacksburg
## 934 Virginia VA Portsmouth
## 935 Virginia VA Hampton
## 936 Virginia VA Newport News
## 937 Virginia VA Leesburg
## 938 Virginia VA Danville
## 939 Virginia VA Charlottesville
## 940 Virginia VA Lynchburg
## 941 Virginia VA Manassas
## 942 Virginia VA Virginia Beach
## 943 Virginia VA Chesapeake
## 944 Virginia VA Richmond
## 945 Virginia VA Roanoke
## 946 Virginia VA Norfolk
## 947 Virginia VA Harrisonburg
## 948 Virginia VA Suffolk
## 949 Washington WA Kennewick
## 950 Washington WA Bellevue
## 951 Washington WA Shoreline
## 952 Washington WA Sammamish
## 953 Washington WA Lacey
## 954 Washington WA Everett
## 955 Washington WA Auburn
## 956 Washington WA Yakima
## 957 Washington WA Kent
## 958 Washington WA Spokane
## 959 Washington WA Puyallup
## 960 Washington WA Lakewood
## 961 Washington WA Federal Way
## 962 Washington WA Pasco
## 963 Washington WA Kirkland
## 964 Washington WA Spokane Valley
## 965 Washington WA Renton
## 966 Washington WA Vancouver
## 967 Washington WA Seattle
## 968 Washington WA Edmonds
## 969 Washington WA Olympia
## 970 Washington WA Richland
## 971 Washington WA Bellingham
## 972 Washington WA Bremerton
## 973 Washington WA Marysville
## 974 Washington WA Redmond
## 975 Washington WA Burien
## 976 Washington WA Tacoma
## 977 West Virginia WV Charleston
## 978 West Virginia WV Huntington
## 979 Wisconsin WI Sheboygan
## 980 Wisconsin WI Waukesha
## 981 Wisconsin WI Brookfield
## 982 Wisconsin WI Appleton
## 983 Wisconsin WI Janesville
## 984 Wisconsin WI West Allis
## 985 Wisconsin WI Racine
## 986 Wisconsin WI La Crosse
## 987 Wisconsin WI Kenosha
## 988 Wisconsin WI Eau Claire
## 989 Wisconsin WI Wausau
## 990 Wisconsin WI New Berlin
## 991 Wisconsin WI Madison
## 992 Wisconsin WI Wauwatosa
## 993 Wisconsin WI Greenfield
## 994 Wisconsin WI Oshkosh
## 995 Wisconsin WI Fond du Lac
## 996 Wisconsin WI Milwaukee
## 997 Wisconsin WI Green Bay
## 998 Wisconsin WI Beloit
## 999 Wyoming WY Casper
## 1000 Wyoming WY Cheyenne
## growth_from_2000_to_2013 latitude longitude population rank
## 1 -1.9% 30.69537 -88.03989 194899 122
## 2 31.9% 32.47098 -85.00077 37498 983
## 3 -0.1% 32.36681 -86.29997 201332 111
## 4 3.1% 34.60593 -86.98334 55816 653
## 5 16.3% 34.73037 -86.58610 186254 126
## 6 53.7% 34.69926 -86.74833 45799 811
## 7 21.1% 33.20984 -87.56917 95334 313
## 8 10.2% 34.79981 -87.67725 40059 922
## 9 26.4% 32.60986 -85.48078 58582 615
## 10 32.7% 33.40539 -86.81138 84126 376
## 11 16.6% 31.22323 -85.39049 68001 502
## 12 -12.3% 33.52066 -86.80249 212113 101
## 13 15.4% 61.21806 -149.90028 300950 63
## 14 86.0% 32.87950 -111.75735 50111 743
## 15 96.0% 33.35283 -111.78903 229972 92
## 16 281.9% 33.62923 -112.36793 123546 216
## 17 11.0% 33.49417 -111.92605 226918 95
## 18 15.9% 35.13594 -114.52860 39383 941
## 19 5.7% 33.53865 -112.18599 234632 87
## 20 18.1% 34.54002 -112.46850 40590 907
## 21 13.5% 33.41518 -111.83147 457587 38
## 22 5.8% 33.42551 -111.94001 168228 143
## 23 29.3% 35.19828 -111.65130 68667 495
## 24 166.2% 32.43638 -111.22244 38290 964
## 25 7.5% 32.22174 -110.92648 526116 33
## 26 15.7% 33.41505 -111.54958 37130 994
## 27 62.9% 34.61002 -112.31572 39791 929
## 28 46.5% 33.58060 -112.23738 162592 149
## 29 111.5% 33.43560 -112.34960 78822 413
## 30 2503.4% 33.05811 -112.04764 45508 817
## 31 16.2% 32.69265 -114.62769 91923 330
## 32 14.0% 33.44838 -112.07404 1513367 6
## 33 271.0% 33.43534 -112.35766 72864 462
## 34 38.7% 33.30616 -111.84125 249146 79
## 35 480.9% 33.37032 -112.58378 56683 641
## 36 27.0% 32.39091 -110.96649 41627 883
## 37 19.3% 31.54550 -110.27729 45129 823
## 38 24.6% 34.48390 -114.32245 52844 695
## 39 97.7% 36.37285 -94.20882 40167 921
## 40 -16.2% 34.22843 -92.00320 46094 805
## 41 57.1% 36.18674 -94.12881 75229 443
## 42 50.6% 36.33202 -94.11854 60112 591
## 43 46.1% 35.08870 -92.44210 63816 546
## 44 8.6% 35.38592 -94.39855 87650 355
## 45 9.0% 34.76954 -92.26709 66075 524
## 46 28.3% 35.84230 -90.70428 71551 469
## 47 32.9% 36.06258 -94.15743 78960 411
## 48 7.6% 34.74648 -92.28959 197357 118
## 49 97.1% 38.40880 -121.37162 161007 151
## 50 5.7% 32.83838 -116.97392 56105 648
## 51 8.4% 38.29754 -122.28687 79068 409
## 52 55.4% 33.49364 -117.14836 106780 266
## 53 2.9% 33.83167 -118.28169 92599 325
## 54 5.0% 37.97353 -122.53109 58994 609
## 55 2.1% 34.05510 -117.74999 151348 162
## 56 3.5% 37.91008 -122.06518 66900 513
## 57 9.0% 37.56299 -122.32553 101128 286
## 58 33.8% 34.68678 -118.15416 159523 153
## 59 15.2% 38.44043 -122.71405 171990 140
## 60 6.6% 33.19587 -117.37948 172794 137
## 61 107.4% 33.55391 -117.21392 107479 263
## 62 -0.7% 34.09529 -118.12701 84577 372
## 63 5.5% 34.06334 -117.65089 167500 144
## 64 15.1% 37.68187 -121.76801 85156 370
## 65 15.3% 34.39166 -118.54259 179590 133
## 66 28.6% 33.42697 -117.61199 65040 537
## 67 7.7% 37.77493 -122.41942 837442 14
## 68 4.8% 34.05223 -118.24368 3884307 2
## 69 38.3% 34.09223 -117.43505 203003 109
## 70 -0.8% 33.95474 -118.21202 95677 312
## 71 33.99720 -117.48548 98030 300
## 72 5.4% 37.76521 -122.24164 76419 435
## 73 32.7% 34.10640 -117.59311 171386 141
## 74 18.3% 36.74684 -119.77259 509924 34
## 75 17.2% 38.58157 -121.49440 479686 35
## 76 4.4% 35.28275 -120.65962 46377 802
## 77 1.9% 33.90224 -118.08173 106589 267
## 78 2.0% 34.01651 -118.11375 63495 549
## 79 30.9% 34.95303 -120.43572 102216 281
## 80 13.4% 33.88863 -117.81311 67032 511
## 81 18.2% 34.19750 -119.17705 203007 108
## 82 9.8% 34.10640 -117.37032 101910 284
## 83 39.7% 33.15809 -117.35059 110972 244
## 84 9.6% 34.01945 -118.49119 92472 326
## 85 1.3% 37.80436 -122.27111 406253 45
## 86 65.8% 37.77993 -121.97802 74513 449
## 87 -0.1% 38.70712 -121.28106 85285 369
## 88 10.5% 32.71574 -117.16108 1355896 8
## 89 11.9% 37.36883 -122.03635 147559 170
## 90 21.8% 37.95770 -121.29078 298118 64
## 91 10.5% 37.33821 -121.88633 998537 10
## 92 48.4% 35.37329 -119.01871 363630 52
## 93 1.5% 34.06251 -118.12285 61085 577
## 94 0.3% 34.14251 -118.25508 196021 121
## 95 2.8% 33.52253 -117.70755 64652 539
## 96 4.7% 33.83529 -117.91450 345012 56
## 97 -1.2% 33.74557 -117.86783 334227 57
## 98 15.6% 33.74585 -117.82617 78327 420
## 99 22.5% 33.95335 -117.39616 316619 59
## 100 13.0% 34.10834 -117.28977 213708 100
## 101 7.7% 33.78779 -117.85311 139969 182
## 102 1.2% 38.10409 -122.25664 118837 223
## 103 98.7% 33.78252 -117.22865 72326 466
## 104 60.0% 33.14337 -117.16614 89387 346
## 105 7.7% 37.63910 -120.99688 204933 105
## 106 10.1% 38.13415 -121.27222 63338 550
## 107 42.6% 36.82523 -119.70292 99769 296
## 108 0.2% 34.14426 -118.00195 37101 995
## 109 14.2% 39.72849 -121.83748 88077 350
## 110 13.3% 37.87159 -122.27275 116768 231
## 111 1.0% 37.68792 -122.47021 104739 273
## 112 40.4% 33.94247 -117.22967 201175 112
## 113 4.2% 34.18084 -118.30897 104709 274
## 114 10.4% 33.61891 -117.92895 87273 356
## 115 5.4% 38.35658 -121.98774 94275 316
## 116 33.7% 34.57943 -118.11646 157161 156
## 117 25.4% 37.30216 -120.48297 81102 400
## 118 7.7% 33.83030 -116.54529 46281 804
## 119 23.5% 37.49466 -120.84659 70365 482
## 120 2.9% 33.60002 -117.67200 96346 309
## 121 7.5% 37.66882 -122.08080 151574 161
## 122 2.3% 33.91640 -118.35257 86199 364
## 123 12.1% 34.07751 -117.68978 38027 969
## 124 9.4% 34.05557 -117.18254 69999 486
## 125 91.8% 33.78391 -116.95864 45851 810
## 126 11.0% 37.43233 -121.89957 69783 489
## 127 27.9% 39.14045 -121.61691 65416 530
## 128 -4.1% 33.98168 -118.22507 58879 612
## 129 12.6% 34.26945 -118.78148 126181 210
## 130 3.9% 33.75134 -117.99399 91739 331
## 131 6.6% 33.83585 -118.34063 147478 171
## 132 -3.6% 33.85835 -118.06479 49707 750
## 133 11.9% 40.58654 -122.39168 91119 334
## 134 12.8% 38.24936 -122.03997 109320 255
## 135 5.8% 33.77391 -117.94145 175140 135
## 136 31.8% 35.76884 -119.24705 52403 701
## 137 7.4% 34.27465 -119.22903 108817 258
## 138 10.0% 37.54827 -121.98857 224922 97
## 139 122.3% 37.93187 -121.69579 55000 663
## 140 2.3% 34.06862 -117.93895 107740 261
## 141 7.9% 37.93576 -122.34775 107571 262
## 142 95.0% 33.69715 -117.18529 83447 384
## 143 3.8% 34.14778 -118.14452 139731 183
## 144 16.9% 38.00492 -121.80579 107100 265
## 145 11.9% 38.54491 -121.74052 66205 521
## 146 30.3% 36.32745 -119.64568 54686 670
## 147 -1.6% 34.02001 -117.94951 40435 911
## 148 1.7% 34.08057 -118.07285 54561 672
## 149 0.1% 34.02862 -117.81034 56449 646
## 150 2.4% 32.96282 -117.03586 49417 755
## 151 0.8% 34.08529 -117.96090 76635 433
## 152 13.6% 33.98982 -117.73258 76572 434
## 153 12.5% 36.97412 -122.03080 62864 556
## 154 23.6% 33.87529 -117.56644 159503 154
## 155 29.9% 34.50083 -117.18588 70924 477
## 156 46.2% 32.64005 -117.08420 256780 75
## 157 9.5% 34.17056 -118.83759 128731 198
## 158 2.9% 37.97798 -122.03107 125880 211
## 159 9.1% 37.65466 -122.40775 66174 522
## 160 3.7% 37.82159 -121.99996 43341 846
## 161 33.6% 36.33023 -119.29206 127763 201
## 162 6.7% 34.13362 -117.90756 47842 780
## 163 7.1% 37.48522 -122.23635 80872 403
## 164 20.1% 36.06523 -119.01677 55174 661
## 165 59.9% 33.66336 -116.31001 39331 943
## 166 10.7% 33.11921 -117.08642 148738 166
## 167 5.8% 33.03699 -117.29198 61588 570
## 168 15.2% 37.66243 -121.87468 74110 450
## 169 45.9% 37.73965 -121.42522 84691 371
## 170 6.9% 32.76783 -117.02308 58642 613
## 171 9.8% 33.87036 -117.92430 138981 184
## 172 7.7% 33.20004 -117.24254 96929 306
## 173 14.3% 37.32300 -122.03218 60189 589
## 174 19.5% 37.13050 -121.65439 40836 900
## 175 23.9% 37.00578 -121.56828 51701 712
## 176 25.4% 33.56768 -117.72561 50175 741
## 177 3.4% 33.88835 -118.30896 59957 593
## 178 10.3% 37.72493 -122.15608 87965 352
## 179 87.6% 34.53622 -117.29276 121096 218
## 180 4.5% 33.89585 -118.22007 97877 301
## 181 66.0% 33.72058 -116.21556 83539 382
## 182 10.1% 37.38605 -122.08385 77846 424
## 183 7.4% 37.59339 -122.04383 72528 465
## 184 3.0% 33.70918 -117.95367 56707 640
## 185 3.9% 33.66030 -117.99923 197575 117
## 186 2.4% 33.64113 -117.91867 112174 239
## 187 15.6% 34.01223 -117.68894 80988 402
## 188 14.9% 34.21639 -119.03760 66086 523
## 189 -1.0% 33.96168 -118.35313 111542 242
## 190 33.95246 -117.58480 55191 660
## 191 285.2% 38.89156 -121.29301 45237 822
## 192 10.1% 32.67811 -117.09920 59834 595
## 193 13.3% 38.10742 -122.56970 54194 676
## 194 -0.4% 34.06862 -118.02757 115708 234
## 195 13.7% 37.44188 -122.14302 66642 517
## 196 0.5% 37.61383 -122.48692 38606 960
## 197 3.3% 34.09001 -117.89034 48508 774
## 198 1.3% 34.02112 -118.39647 39428 936
## 199 42.7% 37.79743 -121.21605 71948 467
## 200 3.4% 38.01937 -122.13413 37165 992
## 201 26.8% 34.03363 -117.04309 52536 698
## 202 12.7% 36.91023 -121.75689 52477 699
## 203 7.4% 32.79477 -116.96253 102211 282
## 204 2.0% 33.93029 -118.21146 71371 471
## 205 3.3% 37.52966 -122.04024 44096 835
## 206 61.3% 33.68395 -117.79469 236716 85
## 207 4.2% 33.64697 -117.68922 79312 408
## 208 13.2% 33.72224 -116.37446 50508 732
## 209 23.2% 33.78054 -116.46680 52977 693
## 210 8.3% 34.13973 -118.03534 57639 626
## 211 5.6% 37.63049 -122.41108 42443 868
## 212 1.5% 33.77005 -118.19374 469428 36
## 213 5.3% 33.94011 -118.13316 113242 238
## 214 13.7% 32.79200 -115.56305 43363 845
## 215 9.5% 34.09751 -117.64839 75413 442
## 216 44.0% 32.67895 -115.49888 39389 940
## 217 5.5% 34.63915 -120.45794 43509 844
## 218 -2.7% 33.96529 -118.15146 42889 862
## 219 44.4% 36.96134 -120.06072 63105 554
## 220 17.4% 37.35411 -121.95524 120245 220
## 221 -0.7% 33.88946 -118.15979 54980 664
## 222 70.0% 37.70215 -121.93579 52105 706
## 223 4.6% 33.64086 -117.60310 49228 758
## 224 10.8% 34.07390 -117.31365 53243 690
## 225 2.9% 33.74446 -118.38702 42448 867
## 226 6.1% 33.86751 -117.99812 82882 386
## 227 6.3% 33.88168 -118.11701 77593 427
## 228 33.3% 36.20773 -119.34734 61170 576
## 229 47.7% 37.99742 -121.71245 38194 966
## 230 0.0% 38.33964 -122.70110 41398 885
## 231 3.1% 34.13612 -117.86534 51074 723
## 232 38.6% 38.67796 -121.17606 73098 458
## 233 2.8% 33.80252 -117.99312 38623 958
## 234 37.6% 33.74752 -116.97197 81750 395
## 235 60.3% 38.79073 -121.23578 59738 597
## 236 88.4% 33.68030 -116.17389 43092 853
## 237 4.2% 37.28717 -121.94996 40584 908
## 238 55.6% 38.58046 -121.53023 49891 746
## 239 4.6% 33.91724 -118.01201 49133 761
## 240 8.4% 36.67774 -121.65550 155662 157
## 241 13.8% 38.67852 -121.77330 56590 643
## 242 3.3% 33.97918 -118.03284 86635 360
## 243 8.4% 38.23242 -122.63665 59440 601
## 244 2.1% 33.85363 -118.13396 81121 399
## 245 5.3% 33.81696 -118.03729 49087 762
## 246 3.6% 33.93196 -117.94617 61653 569
## 247 56.2% 38.75212 -121.28801 127035 206
## 248 15.2% 33.91668 -117.90006 40963 893
## 249 6.7% 33.84918 -118.38841 67815 504
## 250 96.5% 33.66808 -117.32726 57525 628
## 251 254.5% 33.92946 -116.97725 40481 910
## 252 0.9% 34.42083 -119.69819 90412 339
## 253 0.4% 33.98307 -118.09673 63771 547
## 254 16.6% 38.02798 -121.88468 66695 516
## 255 26.4% 38.58907 -121.30273 67911 503
## 256 34.0% 37.59493 -120.95771 46714 797
## 257 11.8% 33.87224 -117.87034 52206 704
## 258 0.9% 34.09611 -118.10583 40275 919
## 259 46.1% 34.42639 -117.30088 92147 327
## 260 21.0% 34.12834 -117.20865 54291 675
## 261 3.5% 39.58075 -104.87717 106114 268
## 262 52.9% 39.86804 -104.97192 127359 205
## 263 1.9% 39.70471 -105.08137 147214 173
## 264 96.4% 39.51860 -104.76136 48608 770
## 265 5.9% 38.25445 -104.60914 108249 259
## 266 23.1% 40.42331 -104.70913 96539 308
## 267 37.4% 40.39776 -105.07498 71334 472
## 268 153.5% 39.37221 -104.85609 53063 692
## 269 135.4% 39.80832 -104.93387 49799 748
## 270 26.6% 40.58526 -105.08442 152061 160
## 271 9.4% 39.61332 -105.01665 44275 832
## 272 9.4% 39.83665 -105.03720 110945 245
## 273 21.4% 38.83388 -104.82136 439886 41
## 274 16.7% 39.73924 -104.99025 649495 22
## 275 24.4% 40.16721 -105.10193 89919 344
## 276 24.4% 39.72943 -104.83192 345803 55
## 277 9.2% 39.80276 -105.08748 111707 241
## 278 15.5% 39.89618 -104.98115 37499 982
## 279 30.9% 39.06387 -108.55065 59778 596
## 280 50.3% 39.92054 -105.08665 59471 600
## 281 9.0% 40.01499 -105.27055 103166 279
## 282 5.4% 41.18655 -73.19518 147216 172
## 283 11.4% 41.39482 -73.45401 83684 380
## 284 1.9% 41.66121 -72.77954 72939 461
## 285 3.6% 41.56232 -72.65065 47333 791
## 286 7.6% 41.05343 -73.53873 126456 209
## 287 5.5% 41.30827 -72.92788 130660 195
## 288 1.8% 41.23070 -73.06404 51644 713
## 289 0.6% 41.76371 -72.68509 125017 212
## 290 5.1% 41.27055 -72.94697 55046 662
## 291 5.6% 41.11774 -73.40816 87776 354
## 292 0.4% 41.67176 -72.94927 60568 583
## 293 3.7% 41.53815 -72.80704 60456 586
## 294 7.3% 41.31649 -73.09316 40999 892
## 295 2.2% 41.55815 -73.05150 109676 253
## 296 11.6% 41.52426 -72.07591 40347 917
## 297 -1.6% 39.73907 -75.53979 71525 470
## 298 16.0% 39.15817 -75.52437 37366 987
## 299 13.0% 38.90719 -77.03687 646449 23
## 300 4.2% 26.14036 -80.21338 69813 488
## 301 21.8% 30.43826 -84.28073 186411 125
## 302 10.5% 25.94204 -80.24560 111378 243
## 303 3.6% 25.93315 -80.16255 43250 850
## 304 137.6% 25.81954 -80.35533 50213 738
## 305 18.3% 28.03947 -81.94980 100710 289
## 306 12.9% 26.21286 -80.24977 63155 553
## 307 0.7% 26.12244 -80.13732 172389 139
## 308 0.1% 27.96585 -82.80010 109703 252
## 309 1.4% 27.33643 -82.53065 53326 688
## 310 2.0% 28.66111 -81.36562 42150 873
## 311 31.7% 28.03446 -80.58866 104898 270
## 312 12.8% 29.65163 -82.32483 127488 204
## 313 7.8% 28.61222 -80.80755 44206 833
## 314 6.1% 26.46146 -80.07282 64072 543
## 315 39.6% 26.82339 -80.13865 50699 728
## 316 28.4% 26.25175 -80.17894 56792 636
## 317 5.9% 27.84280 -82.69954 49998 744
## 318 86.2% 28.24890 -81.28118 40918 898
## 319 22.8% 29.13832 -80.99561 57203 631
## 320 3.4% 27.49893 -82.57482 51763 711
## 321 142.5% 28.56528 -81.58618 37711 975
## 322 23.1% 28.90054 -81.26367 86290 363
## 323 34.5% 26.10037 -80.39977 68388 497
## 324 5.1% 27.90947 -82.78732 78409 418
## 325 16.1% 25.72149 -80.26838 49631 752
## 326 14.9% 25.76168 -80.19179 417650 44
## 327 100.7% 25.46872 -80.47756 64079 542
## 328 74.7% 25.98608 -80.30356 130288 196
## 329 154.6% 27.04422 -82.23593 59212 606
## 330 6.9% 27.44671 -80.32561 43074 854
## 331 32.6% 28.29196 -81.40757 65173 534
## 332 -6.0% 30.42131 -87.21691 52703 696
## 333 137.2% 29.58445 -81.20787 78740 415
## 334 14.3% 30.33218 -81.65565 842583 13
## 335 3.3% 25.79065 -80.13005 91026 336
## 336 23.5% 26.71534 -80.05337 102436 280
## 337 17.4% 26.00776 -80.29626 162329 150
## 338 46.2% 26.93422 -80.09421 58298 619
## 339 8.6% 26.12759 -80.23310 90268 340
## 340 5.8% 29.28581 -81.05589 38661 956
## 341 4.0% 26.23786 -80.12477 104410 276
## 342 2.7% 26.24453 -80.20644 55456 656
## 343 57.9% 28.56917 -81.54396 39172 947
## 344 31.2% 28.53834 -81.37924 255483 77
## 345 3.2% 25.85760 -80.27811 233394 89
## 346 63.9% 28.69341 -81.53221 45587 815
## 347 17.7% 26.07648 -80.25212 96830 307
## 348 5.9% 28.08363 -80.60811 77508 428
## 349 2.7% 26.17231 -80.13199 43286 849
## 350 4.8% 26.01120 -80.14949 146526 174
## 351 0.1% 30.15881 -85.66021 36877 1000
## 352 12.4% 25.98120 -80.14838 38632 957
## 353 5.7% 26.27119 -80.27060 126604 208
## 354 4.6% 26.16697 -80.25659 90116 342
## 355 0.3% 27.77306 -82.64000 249688 78
## 356 17.3% 26.53179 -80.09055 71097 474
## 357 16.0% 27.95058 -82.45718 352957 53
## 358 -2.3% 29.21081 -81.02283 62316 559
## 359 31.2% 26.64063 -81.87231 68190 501
## 360 60.4% 26.56285 -81.94953 165831 146
## 361 43.8% 26.33981 -81.77870 47547 787
## 362 2.0% 25.89009 -80.18671 61007 580
## 363 7.5% 26.36831 -80.12893 89407 345
## 364 10.8% 26.21730 -80.22588 42757 864
## 365 42.8% 28.80286 -81.26945 56002 650
## 366 35.5% 26.62763 -80.13539 38696 955
## 367 91.7% 27.27305 -80.35823 171016 142
## 368 47.2% 25.95648 -80.13921 37199 991
## 369 4.8% 26.31841 -80.09977 78041 422
## 370 42.9% 25.58083 -80.34686 43328 848
## 371 20.8% 29.18720 -82.14009 57468 629
## 372 55.0% 26.66176 -80.26836 60202 588
## 373 6.2% 33.74900 -84.38798 447841 40
## 374 -3.8% 33.95260 -84.54993 59089 608
## 375 15.2% 34.02324 -84.36156 94034 318
## 376 20.0% 33.88399 -84.51438 53438 687
## 377 33.96989 -84.22146 40059 923
## 378 17.4% 33.93044 -84.37331 99770 295
## 379 36.5% 34.02893 -84.19858 82788 389
## 380 19.0% 33.95193 -83.35757 119980 222
## 381 8.7% 32.46098 -84.98771 202824 110
## 382 33.94621 -84.33465 47591 784
## 383 1.1% 33.47350 -82.01051 197350 119
## 384 22.3% 30.83270 -83.27849 56481 645
## 385 -0.6% 31.57851 -84.15574 76185 436
## 386 45.7% 32.61300 -83.62420 72531 464
## 387 -7.3% 32.84069 -83.63240 89981 343
## 388 33.86510 -84.33659 50603 729
## 389 7.5% 32.08354 -81.09983 142772 180
## 390 33.6% 34.07538 -84.29409 62298 560
## 391 -6.2% 21.30694 -157.85833 347884 54
## 392 14.0% 43.49165 -112.03396 58292 620
## 393 31.5% 42.56297 -114.46087 45981 808
## 394 5.4% 42.87130 -112.44553 54350 674
## 395 77.1% 43.66294 -116.68736 48957 763
## 396 127.6% 43.61211 -116.39151 83596 381
## 397 32.8% 47.67768 -116.78047 46402 801
## 398 57.9% 43.54072 -116.56346 86518 361
## 399 9.5% 43.61871 -116.21461 214237 98
## 400 -0.2% 41.91253 -88.13479 40379 914
## 401 16.0% 42.03541 -88.28257 110145 249
## 402 -1.0% 42.27113 -89.09400 150251 164
## 403 -1.6% 41.84559 -87.75394 84103 377
## 404 10.1% 42.02558 -88.17841 40351 916
## 405 0.5% 39.93560 -91.40987 40915 899
## 406 0.1% 42.01114 -87.84062 37839 972
## 407 2.8% 42.03240 -87.74162 65176 533
## 408 13.1% 41.99503 -88.18563 41679 881
## 409 -1.9% 41.50670 -90.51513 43116 852
## 410 11.8% 41.92947 -88.75036 43849 840
## 411 3.3% 41.71998 -87.74795 57073 633
## 412 29.7% 41.69864 -88.06840 73936 454
## 413 36.5% 41.52503 -88.08173 147806 169
## 414 19.7% 40.51420 -88.99063 54664 671
## 415 0.5% 42.36363 -87.84479 88826 348
## 416 22.8% 42.12114 -88.25786 38241 965
## 417 5.3% 42.24113 -88.31620 40388 912
## 418 -3.4% 42.16628 -87.96313 41778 875
## 419 12.0% 41.75084 -88.15354 144864 176
## 420 2.9% 41.88003 -88.00784 43907 838
## 421 3.0% 40.69365 -89.58899 116513 232
## 422 -0.6% 42.08836 -87.98063 75994 437
## 423 13.9% 41.63031 -87.85394 58590 614
## 424 5.7% 41.89947 -87.94034 45556 816
## 425 0.6% 41.99947 -88.14507 38510 961
## 426 18.3% 40.11642 -88.24338 83424 385
## 427 16.3% 41.57314 -87.79329 57282 630
## 428 0.0% 41.80892 -88.01117 49670 751
## 429 -2.5% 42.06642 -87.93729 54771 669
## 430 5.2% 42.06975 -87.78784 45417 819
## 431 38.4% 41.76058 -88.32007 199963 114
## 432 -0.5% 42.03336 -88.08341 74907 445
## 433 79.5% 41.64753 -88.08951 39650 931
## 434 -6.1% 41.87811 -87.62980 2718782 3
## 435 203.6% 41.63222 -88.21203 41734 879
## 436 5.1% 41.85059 -87.79367 56758 638
## 437 3.2% 42.03336 -87.88340 58918 611
## 438 -8.7% 39.84031 -88.95480 74710 448
## 439 10.3% 40.11059 -88.20727 41752 878
## 440 -0.8% 41.88503 -87.78450 52066 707
## 441 -1.9% 41.50948 -90.57875 38877 951
## 442 -3.4% 41.86614 -88.10701 53648 686
## 443 4.5% 42.11030 -88.03424 69350 490
## 444 4.2% 39.78172 -89.65015 117006 230
## 445 2.6% 41.93170 -87.98896 37385 986
## 446 1.2% 38.52005 -89.98399 42895 861
## 447 -4.5% 41.61559 -87.52949 37240 989
## 448 4.8% 42.13919 -87.92896 38015 970
## 449 20.1% 40.48420 -88.99369 78902 412
## 450 1.9% 42.04507 -87.68770 75570 439
## 451 5.4% 42.06299 -88.12272 52398 702
## 452 -23.4% 41.59337 -87.34643 78450 417
## 453 2.5% 39.46670 -87.41391 61025 579
## 454 7.8% 39.76840 -86.15807 843393 12
## 455 16.1% 39.16533 -86.52639 82575 392
## 456 14.5% 40.41670 -86.87529 70373 481
## 457 88.1% 40.04559 -86.00860 56540 644
## 458 2.0% 41.66199 -86.15862 47989 778
## 459 -0.7% 40.19338 -85.38636 70316 483
## 460 60.4% 39.97837 -86.11804 85927 366
## 461 16.4% 39.20144 -85.92138 45775 813
## 462 21.3% 40.48643 -86.13360 56895 635
## 463 -4.6% 41.58337 -87.50004 78967 410
## 464 -6.6% 40.10532 -85.68025 55670 655
## 465 46.0% 39.61366 -86.10665 53665 684
## 466 20.5% 39.83865 -86.02526 47135 794
## 467 -2.5% 41.68199 -85.97667 51265 721
## 468 -0.8% 37.97156 -87.57109 120310 219
## 469 53.3% 38.27757 -85.73718 45929 809
## 470 114.8% 39.95675 -86.01335 83891 378
## 471 -6.8% 41.67635 -86.25199 100886 288
## 472 1.0% 41.07927 -85.13935 256496 76
## 473 13.8% 41.66113 -91.53017 71591 468
## 474 5.4% 41.97788 -91.66562 128429 199
## 475 3.9% 41.52364 -90.57764 102157 283
## 476 -2.9% 42.49999 -96.40031 82459 393
## 477 21.3% 42.03472 -93.62000 61792 568
## 478 0.9% 42.50056 -90.66457 58253 621
## 479 86.9% 41.73179 -93.60013 51567 715
## 480 29.8% 41.57721 -93.71133 61255 574
## 481 6.2% 41.26194 -95.86083 61969 565
## 482 3.9% 41.60054 -93.60911 207510 104
## 483 41.5% 41.62666 -93.71217 41776 876
## 484 12.0% 42.53490 -92.44532 40566 909
## 485 -0.5% 42.49279 -92.34258 68366 498
## 486 19.4% 38.98223 -94.67079 181260 132
## 487 9.7% 37.68889 -97.33611 386552 49
## 488 4.5% 38.84028 -97.61142 47846 779
## 489 24.6% 38.95362 -94.73357 50344 735
## 490 3.4% 39.05582 -95.68902 127679 202
## 491 1.1% 39.11405 -94.62746 148483 168
## 492 0.1% 38.06084 -97.92977 41889 874
## 493 40.4% 38.88140 -94.81913 131885 193
## 494 12.7% 38.97167 -95.23525 90811 338
## 495 22.8% 39.18361 -96.57167 56143 647
## 496 32.2% 39.02285 -94.71519 64323 541
## 497 7.7% 37.77191 -87.11117 58416 617
## 498 18.0% 38.04058 -84.50372 308428 61
## 499 24.1% 36.96852 -86.48080 61488 571
## 500 10.0% 38.25266 -85.75846 609893 28
## 501 -4.7% 39.08367 -84.50855 40956 894
## 502 17.4% 32.51599 -93.73212 66333 518
## 503 4.1% 31.31129 -92.44514 48426 775
## 504 -4.8% 29.99409 -90.24174 66975 512
## 505 -0.1% 32.52515 -93.75018 200327 113
## 506 -21.6% 29.95107 -90.07153 378715 51
## 507 3.0% 30.22659 -93.21738 74024 452
## 508 -6.1% 32.50931 -92.11930 49761 749
## 509 0.4% 30.45828 -91.14032 229426 93
## 510 11.0% 30.22409 -92.01984 124276 214
## 511 3.2% 43.66147 -70.25533 66318 519
## 512 34.0% 39.08400 -77.15276 64072 544
## 513 8.6% 39.00678 -76.77914 56759 637
## 514 25.9% 39.41427 -77.41054 66893 514
## 515 -4.0% 39.29038 -76.61219 622104 26
## 516 24.2% 39.14344 -77.20137 65690 526
## 517 10.4% 39.64176 -77.71999 40612 906
## 518 7.6% 38.97845 -76.49218 38722 954
## 519 3.0% 42.12509 -72.74954 41301 887
## 520 2.7% 42.41843 -71.10616 57170 632
## 521 12.1% 42.40843 -71.05366 42935 858
## 522 7.5% 42.70704 -71.16311 77657 426
## 523 1.2% 41.63622 -70.93420 95078 315
## 524 4.9% 42.33704 -71.20922 87971 351
## 525 -7.1% 41.70032 -70.30020 44641 827
## 526 7.5% 42.52787 -70.92866 52044 708
## 527 2.6% 42.46676 -70.94949 91589 333
## 528 5.8% 42.25288 -71.00227 93494 320
## 529 -1.1% 42.52509 -71.75979 41002 891
## 530 42.21807 -70.94104 55419 657
## 531 3.5% 42.58342 -71.80230 40383 913
## 532 3.4% 42.63342 -71.31617 108861 257
## 533 7.6% 42.34593 -71.55229 39414 937
## 534 0.9% 42.20426 -72.61620 40249 920
## 535 4.6% 41.94454 -71.28561 43886 839
## 536 1.7% 42.14870 -72.60787 55717 654
## 537 0.0% 41.90010 -71.08977 56069 649
## 538 -0.3% 42.08343 -71.01838 94089 317
## 539 5.0% 42.77620 -71.07728 62088 564
## 540 5.0% 42.37649 -71.23561 62227 562
## 541 5.5% 42.37362 -71.10973 107289 264
## 542 4.4% 42.47926 -71.15228 39083 949
## 543 -3.6% 42.45008 -73.24538 44057 836
## 544 2.0% 42.55843 -70.88005 40664 904
## 545 9.4% 42.36008 -71.05888 645966 24
## 546 5.8% 42.26259 -71.80229 182544 129
## 547 10.3% 42.72620 -71.19089 48514 773
## 548 1.6% 42.38760 -71.09950 78804 414
## 549 13.4% 42.40843 -71.01199 53756 682
## 550 -3.7% 41.70149 -71.15505 88697 349
## 551 7.4% 42.42510 -71.06616 60509 585
## 552 7.3% 42.39176 -71.03283 37670 976
## 553 1.1% 42.10148 -72.58981 153703 158
## 554 5.1% 42.51954 -70.89672 42544 866
## 555 -5.4% 42.36837 -83.35271 95208 314
## 556 -2.8% 42.32115 -85.17971 51848 710
## 557 -3.0% 42.33698 -83.27326 56620 642
## 558 -1.0% 42.49726 -82.93714 47555 786
## 559 -1.7% 42.48948 -83.14465 58946 610
## 560 -6.7% 42.47337 -83.22187 73006 459
## 561 -4.7% 42.32420 -83.40021 82578 391
## 562 10.5% 42.86947 -85.64475 50233 737
## 563 0.9% 43.61558 -84.24721 42181 872
## 564 4.2% 42.73698 -84.48387 48554 772
## 565 5.7% 42.20115 -85.58000 47523 788
## 566 -2.0% 42.32226 -83.17631 95884 311
## 567 5.7% 42.65837 -83.14993 72952 460
## 568 -11.4% 42.63892 -83.29105 59887 594
## 569 -6.3% 42.24087 -83.26965 61817 566
## 570 -20.0% 43.01253 -83.68746 99763 297
## 571 -4.4% 42.73253 -84.55553 113972 236
## 572 -2.8% 42.96336 -85.66809 192294 123
## 573 -7.1% 43.23418 -86.24839 37213 990
## 574 -0.9% 42.49899 -83.36772 81295 397
## 575 -6.7% 42.25059 -83.17854 37313 988
## 576 -4.6% 42.49741 -82.89636 60070 592
## 577 2.2% 42.60641 -83.14978 82821 387
## 578 -2.3% 42.51446 -83.01465 134873 189
## 579 -18.2% 43.41947 -83.95081 50303 736
## 580 22.0% 42.48059 -83.47549 57960 624
## 581 2.0% 42.28083 -83.74304 117025 229
## 582 5.2% 42.58031 -83.03020 131224 194
## 583 -27.1% 42.33143 -83.04575 688701 18
## 584 6.5% 42.91336 -85.70531 74100 451
## 585 -1.9% 42.29171 -85.58723 75548 440
## 586 1.3% 44.84080 -93.29828 86319 362
## 587 9.2% 44.73191 -93.21772 50201 739
## 588 16.0% 45.09413 -93.35634 78373 419
## 589 21.3% 46.87376 -96.76780 39398 939
## 590 23.9% 44.01212 -92.48020 110742 246
## 591 39.8% 44.92386 -92.95938 65656 528
## 592 0.6% 45.17324 -93.30301 62103 563
## 593 12.0% 45.01052 -93.45551 73987 453
## 594 2.6% 44.80413 -93.16689 65453 529
## 595 34.3% 44.64969 -93.24272 58562 616
## 596 2.8% 44.95370 -93.08996 294873 66
## 597 7.3% 44.95974 -93.37022 47411 789
## 598 27.3% 45.07246 -93.45579 65415 531
## 599 -0.1% 46.78667 -92.10049 86128 365
## 600 12.3% 44.95302 -92.99522 39765 930
## 601 85.7% 44.79740 -93.52729 39167 948
## 602 24.7% 44.16358 -93.99940 40641 905
## 603 10.9% 45.55795 -94.16324 66297 520
## 604 32.8% 45.16080 -93.23495 60407 587
## 605 4.1% 44.88969 -93.34995 49376 756
## 606 4.5% 44.97775 -93.26501 400070 46
## 607 0.4% 44.92118 -93.46875 51368 720
## 608 13.3% 44.85469 -93.47079 62603 557
## 609 1.9% 44.76774 -93.27772 61434 572
## 610 72.8% 34.98898 -90.01259 50997 724
## 611 -6.8% 32.29876 -90.18481 172638 138
## 612 -0.9% 32.36431 -88.70366 40921 896
## 613 3.1% 31.32712 -89.29034 47556 785
## 614 -0.6% 30.36742 -89.09282 71012 476
## 615 -11.5% 30.39603 -88.88531 44820 825
## 616 6.7% 38.57670 -92.17352 43330 847
## 617 7.8% 37.20896 -93.29230 164122 148
## 618 3.2% 39.09112 -94.41551 117240 227
## 619 31.2% 38.91084 -94.38217 93184 323
## 620 11.2% 37.08423 -94.51328 50789 726
## 621 1.9% 38.66311 -90.57707 47749 782
## 622 9.9% 39.01695 -94.28161 53294 689
## 623 11.3% 38.78811 -90.49744 67569 507
## 624 9.4% 37.30588 -89.51815 38816 953
## 625 -8.2% 38.62700 -90.19940 318416 58
## 626 5.5% 39.09973 -94.57857 467007 37
## 627 -2.8% 38.78922 -90.32261 52363 703
## 628 34.0% 38.95171 -92.33407 115276 235
## 629 4.1% 39.76746 -94.84668 77147 429
## 630 62.6% 38.81061 -90.69985 82809 388
## 631 6.5% 38.78747 -90.62989 54842 667
## 632 18.6% 45.78329 -108.50069 109059 256
## 633 3.9% 47.49418 -111.28334 59351 604
## 634 19.7% 46.87872 -113.99659 69122 491
## 635 41.9% 45.67700 -111.04293 39860 925
## 636 20.5% 41.15436 -95.91456 53663 685
## 637 16.0% 40.92640 -98.34201 50550 731
## 638 18.0% 40.82576 -96.68520 268738 72
## 639 5.9% 41.25236 -95.99799 434353 42
## 640 26.8% 39.52963 -119.81380 233294 90
## 641 24.5% 36.16994 -115.13983 603488 30
## 642 2.9% 39.16380 -119.76740 54080 678
## 643 51.0% 36.03952 -114.98172 270811 71
## 644 92.2% 36.19886 -115.11750 226877 96
## 645 39.4% 39.53491 -119.75269 93282 321
## 646 4.1% 43.20814 -71.53757 42419 869
## 647 2.9% 42.99564 -71.45479 110378 248
## 648 0.4% 42.76537 -71.46757 87137 358
## 649 -1.2% 40.21705 -74.74294 84349 374
## 650 13.3% 40.78788 -74.01431 52122 705
## 651 7.9% 40.85843 -74.16376 85390 368
## 652 9.6% 40.45940 -74.36085 44412 829
## 653 35.8% 40.74399 -74.03236 52575 697
## 654 5.5% 40.66399 -74.21070 127558 203
## 655 9.3% 39.48638 -75.02596 61050 578
## 656 9.7% 40.50677 -74.26542 51982 709
## 657 4.3% 40.85677 -74.12848 70868 478
## 658 2.8% 40.76843 -74.14542 41664 882
## 659 -3.6% 39.92595 -75.11962 76903 430
## 660 2.1% 40.73566 -74.17237 278427 69
## 661 7.2% 40.72816 -74.07764 257342 74
## 662 5.7% 40.63371 -74.40737 50588 730
## 663 5.1% 40.66871 -74.11431 65028 538
## 664 4.7% 40.62205 -74.24459 41301 886
## 665 -2.2% 39.36428 -74.42293 39551 933
## 666 2.9% 40.88593 -74.04347 44113 834
## 667 -7.4% 40.76732 -74.20487 64544 540
## 668 15.5% 40.48622 -74.45182 55831 652
## 669 1.7% 40.69759 -74.26316 68247 499
## 670 -2.2% 40.91677 -74.17181 145948 175
## 671 37.6% 32.31994 -106.76365 101324 285
## 672 18.1% 36.72806 -108.21869 45426 818
## 673 10.5% 35.68698 -105.93780 69976 487
## 674 21.3% 34.40480 -103.20523 39508 934
## 675 23.5% 35.08533 -106.60555 556495 32
## 676 7.5% 33.39427 -104.52302 48611 769
## 677 74.4% 35.23275 -106.66304 91956 329
## 678 -1.4% 40.65760 -73.58318 43167 851
## 679 -4.1% 43.16103 -77.61092 210358 103
## 680 1.5% 42.72841 -73.69179 49974 745
## 681 -11.3% 42.88645 -78.87837 258959 73
## 682 4.1% 42.65258 -73.75623 98424 299
## 683 6.7% 42.81424 -73.93957 65902 525
## 684 1.8% 40.93121 -73.89875 199766 115
## 685 8.5% 41.03399 -73.76291 57866 625
## 686 -10.8% 43.09621 -79.03774 49468 754
## 687 -1.7% 42.09869 -75.91797 46444 800
## 688 3.6% 40.66427 -73.70846 37659 977
## 689 2.2% 43.10090 -75.23266 61808 567
## 690 -0.9% 43.04812 -76.14742 144669 177
## 691 9.9% 40.91149 -73.78235 79446 407
## 692 -0.2% 40.91260 -73.83708 68224 500
## 693 4.8% 40.71278 -74.00594 8405837 1
## 694 4.0% 40.70621 -73.61874 55361 658
## 695 24.8% 34.22573 -77.94471 112067 240
## 696 10.1% 35.72127 -77.91554 49628 753
## 697 7.0% 35.73445 -81.34446 40361 915
## 698 22.3% 36.07264 -79.79198 279639 68
## 699 98.8% 35.73265 -78.85029 42214 871
## 700 5.0% 34.75405 -77.43024 69079 493
## 701 24.3% 35.95569 -80.00532 107741 260
## 702 92.9% 35.41069 -80.84285 50458 733
## 703 41.9% 35.61266 -77.36635 89130 347
## 704 2.4% 35.05266 -78.87836 204408 106
## 705 24.1% 35.91320 -79.05584 59635 598
## 706 55.1% 35.79154 -78.78112 151088 163
## 707 19.6% 35.59506 -82.55149 87236 357
## 708 16.9% 36.09986 -80.24422 236441 86
## 709 39.1% 35.22709 -80.84313 792862 16
## 710 12.1% 36.09569 -79.43780 51510 717
## 711 47.4% 35.40875 -80.57951 83506 383
## 712 29.9% 35.99403 -78.89862 245475 82
## 713 18.6% 35.48736 -80.62173 44359 830
## 714 48.7% 35.77959 -78.63818 431746 43
## 715 -3.1% 35.93821 -77.79053 56954 634
## 716 8.2% 35.26208 -81.18730 73209 457
## 717 20.1% 46.80833 -100.78374 67034 510
## 718 24.9% 46.87719 -96.78980 113658 237
## 719 26.6% 48.23297 -101.29229 46321 803
## 720 11.5% 47.92526 -97.03285 54932 665
## 721 -8.4% 41.59310 -81.52679 48139 777
## 722 -10.1% 39.10312 -84.51202 297517 65
## 723 -0.2% 39.84395 -84.12466 38142 967
## 724 -7.2% 41.45282 -82.18237 63710 548
## 725 19.0% 39.70923 -84.06327 45712 814
## 726 -10.3% 40.79895 -81.37845 72535 463
## 727 -3.7% 41.36838 -82.10765 53956 681
## 728 -18.1% 41.49932 -81.69436 390113 48
## 729 5.8% 41.04422 -83.64993 41512 884
## 730 35.6% 39.88145 -83.09296 37490 984
## 731 5.7% 40.12617 -82.92907 37530 981
## 732 -10.0% 41.66394 -83.55521 282313 67
## 733 -3.1% 39.68950 -84.16883 55870 651
## 734 -8.6% 41.08144 -81.51901 198100 116
## 735 1.2% 39.34547 -84.56032 42635 865
## 736 1.9% 41.31450 -81.83569 44730 826
## 737 2.7% 39.39950 -84.56134 62258 561
## 738 -9.8% 39.92423 -83.80882 59357 603
## 739 -9.4% 41.48199 -81.79819 51143 722
## 740 -8.1% 40.74255 -84.10523 38355 963
## 741 10.7% 39.71368 -82.59933 39325 944
## 742 -10.1% 40.75839 -82.51545 46454 799
## 743 -20.2% 41.09978 -80.64952 65184 532
## 744 14.8% 39.96118 -82.99879 822553 15
## 745 37.6% 40.09923 -83.11408 43607 842
## 746 -6.6% 41.66616 -81.33955 46979 796
## 747 -0.2% 41.13394 -81.48456 49267 757
## 748 -15.2% 41.23756 -80.81842 40768 901
## 749 -10.3% 41.52005 -81.55624 45394 820
## 750 -13.5% 39.75895 -84.19161 143355 179
## 751 -5.9% 41.40477 -81.72291 80429 406
## 752 3.1% 40.05812 -82.40126 47777 781
## 753 -5.7% 39.51506 -84.39828 48630 767
## 754 -0.7% 35.74788 -95.36969 38863 952
## 755 1.3% 36.15398 -95.99278 398121 47
## 756 20.2% 35.46756 -97.51643 610613 27
## 757 4.5% 35.44951 -97.39670 56756 639
## 758 26.9% 35.65283 -97.47810 87004 359
## 759 22.0% 35.22257 -97.43948 118197 225
## 760 28.2% 36.06095 -95.79745 103500 278
## 761 8.1% 36.39559 -97.87839 50725 727
## 762 20.1% 36.11561 -97.05837 47186 792
## 763 4.9% 34.60357 -98.39593 97151 304
## 764 41.5% 35.33951 -97.48670 58414 618
## 765 17.8% 45.43123 -122.77149 50444 734
## 766 11.8% 44.56457 -123.26204 55298 659
## 767 14.4% 44.99012 -123.02621 37064 997
## 768 20.7% 45.50014 -122.43020 109397 254
## 769 36.4% 45.52289 -122.98983 97368 303
## 770 25.5% 44.63651 -123.10593 51583 714
## 771 17.0% 45.48706 -122.80371 93542 319
## 772 15.0% 45.52306 -122.67648 609456 29
## 773 12.4% 44.04624 -123.02203 60177 590
## 774 14.4% 44.05207 -123.08675 159190 155
## 775 17.1% 42.32652 -122.87559 77677 425
## 776 54.3% 44.05817 -121.31531 81236 398
## 777 16.4% 44.94290 -123.03510 160614 152
## 778 5.3% 45.42067 -122.67065 37610 979
## 779 -4.3% 41.24591 -75.88131 41108 889
## 780 8.7% 40.79339 -77.86000 41757 877
## 781 2.6% 39.95258 -75.16522 1553165 5
## 782 4.5% 40.03788 -76.30551 59325 605
## 783 6.4% 39.96260 -76.72774 43935 837
## 784 0.0% 41.40897 -75.66241 75806 438
## 785 0.6% 40.27319 -76.88670 49188 759
## 786 -7.3% 40.51868 -78.39474 45796 812
## 787 5.2% 40.62593 -75.37046 75018 444
## 788 8.0% 40.33565 -75.92687 87893 353
## 789 -2.8% 42.12922 -80.08506 100671 290
## 790 -8.3% 40.44062 -79.99589 305841 62
## 791 11.2% 40.60843 -75.49018 118577 224
## 792 1.4% 41.77982 -71.43728 80566 405
## 793 -4.6% 41.70010 -71.41617 81971 394
## 794 -3.3% 41.81371 -71.37005 47149 793
## 795 2.3% 41.82399 -71.41283 177994 134
## 796 -5.2% 42.00288 -71.51478 41026 890
## 797 -2.5% 41.87871 -71.38256 71172 473
## 798 8.2% 34.85262 -82.39401 61397 573
## 799 11.7% 34.00071 -81.03481 133358 192
## 800 29.2% 32.77647 -79.93105 127999 200
## 801 1.3% 33.92044 -80.34147 41190 888
## 802 62.9% 33.01850 -80.17565 46074 807
## 803 -6.2% 34.94957 -81.93205 37647 978
## 804 53.2% 32.83232 -79.82843 74885 446
## 805 16.0% 32.21632 -80.75261 39412 938
## 806 36.0% 34.92487 -81.02508 69103 492
## 807 26.1% 32.98101 -80.03259 39823 927
## 808 27.4% 32.85462 -79.97481 104054 277
## 809 19.8% 34.19543 -79.76256 37792 973
## 810 31.1% 43.54460 -96.73110 164676 147
## 811 17.9% 44.08054 -103.23101 70812 479
## 812 65.1% 35.84562 -86.39027 117044 228
## 813 16.7% 36.54843 -82.56182 52962 694
## 814 16.2% 36.16266 -86.78160 634464 25
## 815 3.9% 35.96064 -83.92074 183270 128
## 816 4.1% 35.08676 -89.81009 39375 942
## 817 31.7% 35.20453 -89.87398 58226 622
## 818 16.2% 36.31344 -82.35347 65123 535
## 819 43.4% 35.04204 -89.66453 47333 790
## 820 12.9% 35.61452 -88.81395 67685 505
## 821 -5.3% 35.14953 -90.04898 653450 20
## 822 54.9% 35.98284 -86.51860 43060 855
## 823 36.9% 36.52977 -87.35945 142357 181
## 824 31.7% 36.30477 -86.62000 54068 680
## 825 14.1% 35.15952 -84.87661 42774 863
## 826 51.9% 36.03312 -86.78278 40021 924
## 827 48.5% 35.92506 -86.86889 68886 494
## 828 10.5% 35.04563 -85.30968 173366 136
## 829 13.2% 32.94833 -96.72985 104475 275
## 830 14.9% 32.97564 -96.88996 126700 207
## 831 -6.0% 29.88495 -93.93995 54135 677
## 832 13.2% 30.72353 -95.55078 39795 928
## 833 14.1% 27.80058 -97.39638 316381 60
## 834 64.0% 29.70300 -98.12445 63279 551
## 835 31.7% 30.26715 -97.74306 885400 11
## 836 28.9% 33.04623 -96.99417 101074 287
## 837 98.3% 29.50745 -95.09493 90983 337
## 838 10.3% 32.95457 -97.01501 40342 918
## 839 11.6% 33.63566 -96.60888 39296 946
## 840 117.2% 29.56357 -95.28605 100065 292
## 841 45.1% 32.75549 -97.33077 792727 17
## 842 32.5% 33.01457 -97.09696 68609 496
## 843 28.6% 29.52940 -95.20104 37587 980
## 844 20.2% 32.83430 -97.22890 67317 509
## 845 13.3% 32.73569 -97.10807 379577 50
## 846 10.3% 29.38385 -94.90270 46081 806
## 847 27.1% 31.09823 -97.34278 70190 484
## 848 61.9% 30.31188 -95.45605 63032 555
## 849 -15.2% 29.30135 -94.79770 48733 765
## 850 0.7% 33.91371 -98.49339 104898 271
## 851 11.0% 29.76043 -95.36980 2195914 4
## 852 104.0% 33.10317 -96.67055 92020 328
## 853 19.6% 33.57786 -101.85517 239538 84
## 854 91.9% 30.63326 -97.67798 54898 666
## 855 26.8% 25.90175 -97.49748 181860 131
## 856 134.3% 30.50520 -97.82029 61238 575
## 857 43.1% 32.74596 -96.99778 183372 127
## 858 55.7% 26.19480 -98.18362 73790 455
## 859 287.7% 33.15067 -96.82361 136791 186
## 860 19.1% 32.81402 -96.94889 228653 94
## 861 38.2% 27.53057 -99.48032 248142 80
## 862 14.7% 32.76680 -96.59916 143484 178
## 863 11.6% 26.19063 -97.69610 65665 527
## 864 114.2% 32.56319 -97.14168 60872 581
## 865 7.4% 33.42513 -94.04769 37442 985
## 866 10.2% 31.46377 -100.43704 97492 302
## 867 5.8% 32.82346 -97.17057 38448 962
## 868 81.0% 30.50826 -97.67890 109821 251
## 869 18.6% 32.35126 -95.30106 100223 291
## 870 7.5% 28.80527 -97.00360 65098 536
## 871 3.7% 30.08017 -94.12656 117796 226
## 872 123.4% 30.43937 -97.62000 53752 683
## 873 27.6% 26.20341 -98.23001 136639 188
## 874 19.3% 30.67436 -96.36996 78709 416
## 875 85.3% 32.54208 -97.32085 40714 903
## 876 29.1% 29.61968 -95.63495 83860 379
## 877 47.1% 33.21484 -97.13307 123099 217
## 878 28.8% 26.15952 -97.99084 37093 996
## 879 11.6% 32.50070 -94.74049 81443 396
## 880 165.3% 33.19725 -96.63978 148559 167
## 881 5.6% 32.77666 -96.79699 1257676 9
## 882 117.2% 32.93123 -96.45971 40922 895
## 883 7.5% 29.69106 -95.20910 152735 159
## 884 74.5% 26.21591 -98.32529 81050 401
## 885 45.2% 30.62798 -96.33441 100050 293
## 886 12.8% 35.22200 -101.83130 196429 120
## 887 185.2% 33.01512 -96.53888 44575 828
## 888 65.1% 26.30174 -98.16334 80836 404
## 889 31.1% 29.61857 -95.53772 70185 485
## 890 22.4% 33.01984 -96.69889 274409 70
## 891 48.5% 29.88327 -97.94139 54076 679
## 892 2.9% 32.84402 -97.14307 48592 771
## 893 3.6% 32.44874 -99.73314 120099 221
## 894 19.4% 31.77758 -106.44246 674433 19
## 895 13.1% 29.73550 -94.97743 75418 441
## 896 45.7% 33.08061 -96.89283 39458 935
## 897 11.4% 32.79957 -97.26918 43580 843
## 898 52.1% 31.11712 -97.72780 137147 185
## 899 46.4% 32.59208 -96.75611 38071 968
## 900 8.5% 32.91262 -96.63888 234566 88
## 901 30.4% 31.99735 -102.07791 123933 215
## 902 17.6% 32.93429 -97.07807 50195 740
## 903 9.7% 32.65180 -96.90834 39605 932
## 904 15.1% 32.83707 -97.08195 53224 691
## 905 36.0% 32.58970 -96.85707 51483 718
## 906 42.4% 32.58847 -96.95612 46663 798
## 907 12.5% 31.54933 -97.14667 129030 197
## 908 28.6% 32.90290 -96.56388 58043 623
## 909 21.0% 29.42412 -98.49363 1409019 7
## 910 53.3% 32.93419 -97.22930 42907 860
## 911 22.3% 31.84568 -102.36764 110720 247
## 912 176.3% 40.39162 -111.85077 54382 673
## 913 78.1% 40.11496 -111.65492 36956 998
## 914 1.3% 40.56498 -111.83897 90231 341
## 915 53.1% 37.09653 -113.56842 76817 431
## 916 100.1% 40.56217 -111.92966 59366 602
## 917 8.5% 40.29690 -111.69465 91648 332
## 918 22.2% 40.69161 -112.00105 133579 191
## 919 10.0% 40.23384 -111.65853 116288 233
## 920 14.5% 41.73698 -111.83384 48913 764
## 921 20.2% 41.06022 -111.97105 70790 480
## 922 61.6% 40.52189 -111.93910 40921 897
## 923 3.9% 40.88939 -111.88077 43023 856
## 924 5.1% 40.76078 -111.89105 191180 124
## 925 6.6% 40.66689 -111.88799 48612 768
## 926 77.4% 40.52467 -111.86382 45285 821
## 927 13.3% 41.16161 -112.02633 37733 974
## 928 8.6% 41.22300 -111.97383 84249 375
## 929 38.4% 40.60967 -111.93910 110077 250
## 930 2.9% 40.66772 -111.93883 60519 584
## 931 6.1% 44.47588 -73.21207 42284 870
## 932 15.0% 38.80484 -77.04692 148892 165
## 933 9.4% 37.22957 -80.41394 43609 841
## 934 -4.2% 36.83543 -76.29827 96205 310
## 935 -6.6% 37.02987 -76.34522 136699 187
## 936 0.9% 37.08708 -76.47301 182020 130
## 937 66.0% 39.11566 -77.56360 47673 783
## 938 -11.0% 36.58597 -79.39502 42907 859
## 939 10.5% 38.02931 -78.47668 44349 831
## 940 19.5% 37.41375 -79.14225 78014 423
## 941 19.5% 38.75095 -77.47527 41705 880
## 942 5.1% 36.85293 -75.97798 448479 39
## 943 15.1% 36.76821 -76.28749 230571 91
## 944 8.2% 37.54072 -77.43605 214114 99
## 945 3.8% 37.27097 -79.94143 98465 298
## 946 5.0% 36.85077 -76.28587 246139 81
## 947 27.1% 38.44957 -78.86892 51395 719
## 948 33.5% 36.72821 -76.58356 85728 367
## 949 29.1% 46.21125 -119.13723 76762 432
## 950 19.1% 47.61038 -122.20068 133992 190
## 951 2.9% 47.75565 -122.34152 54790 668
## 952 44.1% 47.61627 -122.03557 50169 742
## 953 41.7% 47.03426 -122.82319 44919 824
## 954 9.4% 47.97898 -122.20208 105370 269
## 955 34.9% 47.30732 -122.22845 74860 447
## 956 11.7% 46.60207 -120.50590 93257 322
## 957 54.3% 47.38093 -122.23484 124435 213
## 958 7.0% 47.65878 -117.42605 210721 102
## 959 11.8% 47.18538 -122.29290 38609 959
## 960 1.1% 47.17176 -122.51846 59097 607
## 961 8.8% 47.32232 -122.31262 92734 324
## 962 98.5% 46.23958 -119.10057 67599 506
## 963 87.5% 47.68149 -122.20874 84430 373
## 964 12.6% 47.67323 -117.23937 91113 335
## 965 88.4% 47.48288 -122.21707 97003 305
## 966 14.2% 45.63873 -122.66149 167405 145
## 967 15.6% 47.60621 -122.33207 652405 21
## 968 2.9% 47.81065 -122.37736 40727 902
## 969 12.1% 47.03787 -122.90070 48338 776
## 970 34.6% 46.28569 -119.28446 52413 700
## 971 21.8% 48.74908 -122.47815 82631 390
## 972 4.9% 47.56732 -122.63294 39056 950
## 973 115.7% 48.05176 -122.17708 63269 552
## 974 26.0% 47.67399 -122.12151 57530 627
## 975 56.7% 47.47038 -122.34679 49858 747
## 976 4.9% 47.25288 -122.44429 203446 107
## 977 -4.7% 38.34982 -81.63262 50821 725
## 978 -5.0% 38.41925 -82.44515 49177 760
## 979 -3.9% 43.75083 -87.71453 48725 766
## 980 8.0% 43.01168 -88.23148 71016 475
## 981 -1.9% 43.06057 -88.10648 37999 971
## 982 4.5% 44.26193 -88.41538 73596 456
## 983 5.6% 42.68279 -89.01872 63820 545
## 984 -0.6% 43.01668 -88.00703 60697 582
## 985 -4.4% 42.72613 -87.78285 78199 421
## 986 -0.8% 43.80136 -91.23958 51522 716
## 987 9.5% 42.58474 -87.82119 99889 294
## 988 8.7% 44.81135 -91.49849 67545 508
## 989 1.7% 44.95914 -89.63012 39309 945
## 990 3.6% 42.97640 -88.10842 39834 926
## 991 15.8% 43.07305 -89.40123 243344 83
## 992 0.0% 43.04946 -88.00759 47134 795
## 993 4.8% 42.96140 -88.01259 37159 993
## 994 5.3% 44.02471 -88.54261 66778 515
## 995 1.7% 43.77304 -88.44705 42970 857
## 996 0.3% 43.03890 -87.90647 599164 31
## 997 1.9% 44.51916 -88.01983 104779 272
## 998 2.9% 42.50835 -89.03178 36888 999
## 999 19.9% 42.86663 -106.31308 59628 599
## 1000 16.9% 41.13998 -104.82025 62448 558- Review the structure of dfNew and explain the columns (aka attributes) in that dataframe.
str(dfNew)## 'data.frame': 1000 obs. of 8 variables:
## $ state : chr "Alabama" "Alabama" "Alabama" "Alabama" ...
## $ Abbreviation : chr "AL" "AL" "AL" "AL" ...
## $ city : chr "Mobile" "Phenix City" "Montgomery" "Decatur" ...
## $ growth_from_2000_to_2013: chr "-1.9%" "31.9%" "-0.1%" "3.1%" ...
## $ latitude : num 30.7 32.5 32.4 34.6 34.7 ...
## $ longitude : num -88 -85 -86.3 -87 -86.6 ...
## $ population : num 194899 37498 201332 55816 186254 ...
## $ rank : chr "122" "983" "111" "653" ...#Merging the two data frames added the State and Abbreviation colums to the data set that had the city, population and longitude and latitude dataStep 3: Visualize the data
- Plot points (on top of a map of the US) for each city. Have the color represent the population.
library(ggmap)
bb <- c(left = min(dfNew$long),
bottom = min(dfNew$lat),
right = max(dfNew$long),
top = max(dfNew$lat))
map = get_stamenmap(bb, zoom = 4)
ggmap(map)
ggmap(map) +
geom_point(data= dfNew,
aes(x=longitude,y=latitude, color=population))
- Add a block comment that criticizes the resulting map. It’s not very good.
#Because the plots are reprenting the color and the population it makes it difficult to truly understand what the map is trying to showStep 4: Group by State
- Use group_by and summarise to make a dataframe of state-by-state population. Store the result in dfSimple.
dfSimple <- dfNew %>%
group_by(state)%>%
summarise(total_population = sum(population))
dfSimple## # A tibble: 51 × 2
## state total_population
## <chr> <dbl>
## 1 Alabama 1279813
## 2 Alaska 300950
## 3 Arizona 4691466
## 4 Arkansas 787011
## 5 California 27910620
## 6 Colorado 3012284
## 7 Connecticut 1239817
## 8 Delaware 108891
## 9 District of Columbia 646449
## 10 Florida 7410114
## # … with 41 more rows- Name the most and least populous states in dfSimple and show the code you used to determine them.
summary(dfSimple)## state total_population
## Length:51 Min. : 42284
## Class :character 1st Qu.: 569106
## Mode :character Median : 1327215
## Mean : 2571224
## 3rd Qu.: 2540772
## Max. :27910620dfSimple[which.min(dfSimple$total_population),]## # A tibble: 1 × 2
## state total_population
## <chr> <dbl>
## 1 Vermont 42284#vermont
dfSimple[which.max(dfSimple$total_population),]## # A tibble: 1 × 2
## state total_population
## <chr> <dbl>
## 1 California 27910620#californiaStep 5: Create a map of the U.S., with the color of the state representing the state population
- Make sure to expand the limits correctly and that you have used coord_map appropriately.
library(ggmap)
us <-map_data("state")
head(us)## long lat group order region subregion
## 1 -87.46201 30.38968 1 1 alabama <NA>
## 2 -87.48493 30.37249 1 2 alabama <NA>
## 3 -87.52503 30.37249 1 3 alabama <NA>
## 4 -87.53076 30.33239 1 4 alabama <NA>
## 5 -87.57087 30.32665 1 5 alabama <NA>
## 6 -87.58806 30.32665 1 6 alabama <NA>dfSimple$state <- tolower(dfSimple$state)
head(dfSimple)## # A tibble: 6 × 2
## state total_population
## <chr> <dbl>
## 1 alabama 1279813
## 2 alaska 300950
## 3 arizona 4691466
## 4 arkansas 787011
## 5 california 27910620
## 6 colorado 3012284combined_data <- merge(us, dfSimple, by.x="region", by.y= 'state')
head(combined_data)## region long lat group order subregion total_population
## 1 alabama -87.46201 30.38968 1 1 <NA> 1279813
## 2 alabama -87.48493 30.37249 1 2 <NA> 1279813
## 3 alabama -87.52503 30.37249 1 3 <NA> 1279813
## 4 alabama -87.53076 30.33239 1 4 <NA> 1279813
## 5 alabama -87.57087 30.32665 1 5 <NA> 1279813
## 6 alabama -87.58806 30.32665 1 6 <NA> 1279813ggmap(map) +
geom_polygon(data=combined_data, aes(x= long,y=lat, group=group, fill=total_population),color="black", alpha=0.8,) +
expand_limits(x=combined_data$long, y=combined_data$lat)